SQL Agent Job Schedule Overlap

• greg.cupples

  SSC Veteran

  Points: 261

  More actions

  March 18, 2009 at 9:04 am

  #97432

  I have an SSIS package that performs some data archiving, copying records from one table to another. I need it to run each Sunday, and also on the 1st of each month; I have a schedule created for each of those.

  When the 1st of the month falls on a Sunday, both schedules will of course run. I only want the job to run once on those days. Any ideas?

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  March 18, 2009 at 9:41 am

  #962035

  If both schedules start at the same time of day, then the job will run only one time.