Home Forums SQL Server 2005 T-SQL (SS2K5) SELECT * FROM master.sys.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher' not returning any results though SQL Server Agent is running RE: SELECT * FROM master.sys.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher' not returning any results though SQL Server Agent is running

  • December 22, 2008 at 6:18 am

    #916101

    Hi,

    Let me put it this way...

    Server Name : SQL001

    Instance Name: SQLSRV

    Running since: 15 days

    Now I connect to the server using Management Studio and run below query

    "SELECT * FROM sysprocesses WHERE Program_Name like '%Agent%Refresher'

    It does'nt return any output, but when I go to Services.msc, I'm able to see that SQLSERVERAGENT is running in this instance but not getting listed in above query.

    Now I Restart the SQLSERVERAGENT of this instance and run the same query I get result...

    What has gone wrong? How though SQL Server Agent is running it is not listed in sysprocesses?

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