SQL Agent Job Status

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  February 5, 2009 at 1:11 pm

  #130819

  I am running a job and it is running for 8 hrs now and still am not sure how long it will take to complete. Is there a way i can check % of job comepleted for an ongoing job.

• DBA in Unit 7

  SSCarpal Tunnel

  Points: 4059

  More actions

  February 5, 2009 at 3:36 pm

  #939252

  If you know what the job is doing, you may check the status (percent-complete, estimated complete time) in sys.dm_exec_requests if you could figure out the sessionid, requestid etc...

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  February 6, 2009 at 9:09 am

  #939612

  But with that i dont see any % of completion of my Job.

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  February 6, 2009 at 9:39 am

  #939632

  I am looking to check the status of my job step. one of the step in hte job is running for severeal hours. How can i check how much % of that job step is done.

  thanks

• the__t

  Hall of Fame

  Points: 3260

  More actions

  February 6, 2009 at 9:51 am

  #939645

  I don't know of any out-of-the-box mechanism for what you seek, and if there is one built-in, then I really want to know about it, as well.

  "Got no time for the jibba jabba!"
  -B.A. Baracus