Post reply

Services information

  • October 9, 2008 at 1:04 am

    #131704

    Hi

    Can anyone point out the system tables/views that keep information regarding the services running on a SQL Server instance. Specifically iam looking for SQL Server Agent service and its status i.e. whether it is running or not?

    "Keep Trying"

  • October 9, 2008 at 3:36 am

    #882765

    Anybody?

    "Keep Trying"

  • October 9, 2008 at 4:54 am

    #882795

    Hi,

    Run this code in master...

    select * from sysprocesses where program_name like 'SQLAgent - Generic Refresher%'

    If your SQL Agent is running then you will get output else no output... Hope this helps!

    Regards,
    Sakthi
    My Blog -> http://www.sqlserverdba.co.cc

  • October 10, 2008 at 12:07 am

    #883273

    Thanks for the info 🙂

    In SQL 2005 we need to look at sys.dm_exec_sessions.

    "Keep Trying"

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

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