sql agent running ? mit tsql

if 0<(select count(*) from sys.sysprocesses where program_name like ‘SQLAgent%’)
begin
print ‘sql agent is running’
end
else
begin
print ‘sql agent is not running’
end

Enhanced by Zemanta

Related Posts

No related posts.

Leave a Reply