Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Thursday, December 30, 2010 3:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 7:17 AM
Points: 3, Visits: 138
SELECT * FROM sysprocesses WHERE Program_Name like '%Refresher%' will give you the correct result..
Post #1041235
Posted Tuesday, August 20, 2013 8:16 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 8:09 AM
Points: 1,495, Visits: 2,117
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)


Jason Shadonix
MCTS, SQL 2005
Post #1486271
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse