Job Activity Monitor (and sp_help_job) incorrectly reports job status

• Chris Seller

  SSC Veteran

  Points: 201

  More actions

  February 2, 2006 at 4:43 am

  #168054

  Hi All,

   

  If I view Job Activity Monitor (or execute sp_help_job) via a “sysadmin” connection I can see if a job is currently executing and which step it is on.

   

  If I view Job Activity Monitor (or execute sp_help_job) via a “SQLAgentOperatorRole” or “SQLAgentReaderRole” or“SQLAgentUserRole” connection I can see all the jobs but it shows all the jobs as idle.

   

  Any ideas?

   

  Thanks in advance.

  Chris

• Noman Tariq

  SSCommitted

  Points: 1750

  More actions

  February 6, 2006 at 8:16 am

  #618986

  you can use Log Files to moniter the job's activity and steps as well.

  May this will help you.