meine Sys/Db admin & Developper Notitzen - wer Rechtschreibfehler findet darf sie behalten ...
my Sys/Db Admin and developper notes - I don't care about typos
Monday, August 08, 2011
check sql agent running with tsql
if 0<(select count(*) from sysprocesses where program_name like 'SQLAgent%')
begin
print 'sql agent is running'
end
else
begin
print 'sql agent is not running'
end
No comments:
Post a Comment