InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 09:02:02 GMT20http://www.sqlservercentral.com/Forums/Topic184263-163-1.aspx<P>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. </P>Wed, 25 May 2005 11:23:00 GMTLeo Peysakhovichhttp://www.sqlservercentral.com/Forums/Topic184263-163-1.aspx<P>Instead of using the command shell to see if the SQL Agent Service is running. You could use the following command.</P><P>EXEC master..xp_servicecontrol QueryState, SQLServerAgent</P>Wed, 25 May 2005 10:57:00 GMTchauchnethttp://www.sqlservercentral.com/Forums/Topic184263-163-1.aspxComments posted to this topic are about the content posted at <A HREF="http://www.sqlservercentral.com/columnists/lPeysakhovich/longrunningjobs.asp">http://www.sqlservercentral.com/columnists/lPeysakhovich/longrunningjobs.asp</A>Fri, 20 May 2005 12:47:00 GMTLeo Peysakhovich