ETL Job Scheduling Exclusions

• kcole-825674

  SSC Rookie

  Points: 38

  More actions

  November 20, 2008 at 11:42 am

  #196105

  I have 2 large ETL loads that need to run on the first Sunday of every month. The first load must precede the second. This part is pretty straight forward.

  I have a weekly load that needs to run by itself, excluding the first Sunday of every month. The problem is that some months have 5 Sundays and others have only 4.

  Does anyone know how to schedule a job to run every Sunday, excluding the first Sunday of the month without having the job execute twice on the months that only have 4 Sundays. The options in the monthly schedule are first, second, third, fourth, and last.

  - Kerry

• Glen Sidelnikov

  SSCertifiable

  Points: 6727

  More actions

  November 20, 2008 at 11:54 am

  #901220

  Create a job1 with no associated schedule (your ETL package run).

  Create a job2 which is running every Sunday.

  Job2 consists of 2 steps.

  Step1 - T-SQL - calculate Sunday's dates for current month. Exclude first date.

  Compare getdate() with calculated dates. If they do not match - exit Job2. If they match,

  Step2. execute Job1.