Velvet Dreams
Reputation: 17
Sql Server agent Job the first business day of each month
How can I schedule to run once on the first business day of every month in SQL Server JOB application?
Upvotes: 0
Views: 1638
Answers (1)
bt224
Reputation: 186
Under Frequency, you can choose "The first weekday of every 1 month(s)".
It won't handle holidays, but as far as I know that's the closest you can get with the schedule configuration.
Upvotes: 2
Related Questions
- SQL Jobs Schedule to Not Run on Holidays
- SQL JOB schedule: how to skip certain month
- how to run a JOB in the oracle only once a month, on the first day of the month
- Reoccurring SQL job to run on the 2nd and 4th Thursday of every month
- How to run SQL Agent Job based on specific days?
- SQL Server Agent Job - Schedule based on last working day of month
- First business day of the current month - SQL Server
- Schedule a job on SQL Server for certain months
- SQL Server Agent Job - Pass date and determine if job will run based on Schedule
- SQL Server Agent Job for the first 4 days of Month