October 9, 2008 at 1:04 am
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
Anybody?
"Keep Trying"
October 9, 2008 at 4:54 am
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
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