DTS - howto check a scheduled job current occurence

• kbirdi

  Grasshopper

  Points: 12

  More actions

  February 10, 2006 at 10:56 am

  #365076

  Is there a way to check a job occurence from within the stored procedure that is scheduled to run every 1 day, every 4 hours ? I want to run another process when job executes the store procedure for the last time i.e. 6th time in 24 hrs.Thank you.

• February 13, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Loner

  SSC-Insane

  Points: 21279

  More actions

  February 14, 2006 at 8:37 am

  #620706

  You can use sysjobhistory table in msdb, it will tell you the status, the run time and the duration of the job it runs previous time.

• kevin mann

  Hall of Fame

  Points: 3894

  More actions

  February 15, 2006 at 12:40 pm

  #621173

  Run the first task 5 times on one job (00:00 to 16:01)

  Run the last task on 1 job with 2 steps (20:00 once a day)