May 20, 2005 at 12:47 pm
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/longrunningjobs.asp
May 25, 2005 at 10:57 am
Instead of using the command shell to see if the SQL Agent Service is running. You could use the following command.
EXEC master..xp_servicecontrol QueryState, SQLServerAgent
May 25, 2005 at 11:23 am
Thanks for the tip. But the stored procedure you pointed is undocumented. I am trying to use only documented procs to be able to use it between SQL Server versions. Even Microsoft very seldom changing undocumented stored procs it may happened. Check a good tip about undocumented stored procedures in the last SQL Server Magazine and changes that are done with some of them in sp4.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply