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 19, 2008 at 6:15 am

    #915179

    Sakthivel Chidambaram (12/17/2008)

    But once SQL Server Agent is started, then I'm able to see the program name 'SQLAgent - Generic Refresher' in sysprocesses... Any thoughts are welcome...

    Based on this you say when it is started you can see it.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question