Post reply

SQL Agent Service

  • August 6, 2008 at 8:13 am

    #130618

    Using Transact-SQL, how can I find out whether SQLAgent is running? I am able to view it through SQLServer Management Studio but how about using T-SQL.

    Thanks.

    Sahoong.

  • August 6, 2008 at 9:16 am

    #853906

    You can run this query:

    xp_servicecontrol 'querystate', 'SQLSERVERAGENT'

    Regards,

    Phil

  • August 7, 2008 at 2:23 am

    #854267

    Many thanks Phil!

  • October 24, 2008 at 9:39 am

    #889307

    Phil,

    How do I capture the results of the query in a variable so can perform subsequent business logic in my procedure?

    Thanks.

    Ken

Viewing 4 posts - 1 through 3 (of 3 total)

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