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