November 20, 2008 at 11:42 am
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
November 20, 2008 at 11:54 am
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply