|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Friday, April 26, 2013 6:18 AM
Points: 129,
Visits: 205
|
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Monday, October 22, 2012 6:52 PM
Points: 71,
Visits: 250
|
|
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
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Friday, April 26, 2013 6:18 AM
Points: 129,
Visits: 205
|
|
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.
|
|
|
|