Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Leo Peysakhovich Long Running Jobs RE: Long Running Jobs
chauchnet
SSChasing Mays
Points: 623
More actions
May 25, 2005 at 10:57 am
#561036
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