Hello Experts Exchange
I have a table in SQL Server called Company Period, it has every day of the year and the period that day is in. Please see attached excel file for a sample data.
I need to schedule a SQL Agent Job to run on the second day of a new period for the pervious period.
So for examples on the 02/02/2015 which is the second day for period 2 I need to run it for period 1. I need to do this for every month of the year.
How would I configure the SQL Agent to be able to do this?