Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

SELECT * FROM master.sys.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher' not returning any results though SQL Server Agent is running Expand / Collapse
Posted Thursday, December 30, 2010 3:29 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, January 13, 2016 11:26 PM
Points: 37, Visits: 348
SELECT * FROM sysprocesses WHERE Program_Name like '%Refresher%' will give you the correct result..
Post #1041235
Posted Tuesday, August 20, 2013 8:16 AM


Group: General Forum Members
Last Login: Yesterday @ 4:02 PM
Points: 1,834, Visits: 2,589
I know this is a 3+ year old thread, but I just started having this problem last night. I have a job that runs on a server and checks [servername].master.dbo.sysprocesses for a record like 'SQLAgent%' to verify that they are running.

All of a sudden several servers are showing it as running in the services mmc tool, and jobs are successfully running as scheduled, but no record in sysprocesses.

Did anyone happen to figure out why this behavior happens? (SQL Server 2005)

The Redneck DBA
Post #1486271
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse