How to Check SQLServer Agent Job

• WesJ

  SSC-Addicted

  Points: 429

  More actions

  January 13, 2003 at 12:11 pm

  #174885

  From EM, when an SQLserver Agent job is running, the Status showed "Executing Job....". Can anyone tell me where this status is stored in msdb? I am trying to setup a job to provide a report of if jobs are running at certain times.

  Thanks,

• zach_john

  SSCertifiable

  Points: 5922

  More actions

  January 13, 2003 at 12:31 pm

  #446202

  msdb..Sysjobhistory will tell you when a job completed.

  You can see the job running by

  select program_name from master..sysprocesses.

  look in the results for something like

  SQLAgent - TSQL JobStep (Job 0xE1F0E02DCF02B849AD3B42BF8B63A291 : Step 1)

  There might be another place, trying running profiler to catch where and what is updated - watch master and msdb.

  John Zacharkan

  Edited by - zach_john on 01/13/2003 12:55:15 PM

  
  John Zacharkan