I want to create a new SQL job that runs the beginning of every quarter:
01/01
04/01
07/01
10/01
Is this possible? I know i can set it to run every 90 days but that's not exact. I am using SQL Server 2008. Thanks in advance!
SQL Server Job – How to Create a SQL Job to Run on Specified Dates
sql serversql-server-2008
Related Question
- Sql-server – Generic SQL Job Scheduler for multiple RDBMS’s
- SQL Server – Run Job Once a Minute Except During Certain Time
- SQL Server – How to Disable Data Type Check When Pushing Data to Linked Server
- SQL Server Agent – Schedule Job Only if CPU is Idle
- Sql-server – SQL Server agent job scripts
- How to Create a Copy of a SQL Server Job
- Sql-server – SQL Server agent job dependency
Best Answer
You can't do this using the point-and-click UI, because it is primitive and inflexible, but you can set the job to run once a month, on the first, and put this in your job step:
If you have multiple steps and want the whole job to exit, rather than having to put that logic in each step, you can reverse the condition and raise an error, and set the step properties to quit the job on error. If you want more graceful failure, you could add a step at the end that quits the job with success, and make that the next step for the first step on error.