Services information

Question

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

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

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

One Orange Chip

Points: 26137

October 9, 2008 at 3:36 am

Anybody?

"Keep Trying"

Sakthivel Chidambaram SSCertifiable Points: 5531 More actions · Answer 2

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!

ChiragNS One Orange Chip Points: 26137 More actions · Answer 3

Thanks for the info

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

"Keep Trying"

Cookies on SQLServerCentral