Long Running Jobs

  • Leo Peysakhovich

    Hall of Fame

    Points: 3880

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/longrunningjobs.asp

  • chauchnet

    SSChasing Mays

    Points: 623

    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

  • Leo Peysakhovich

    Hall of Fame

    Points: 3880

    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 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply