asked
Schedule SQL job as date wise
Hello, I want to schedule SQL job as per date wise like it should run on every 15th and 30th date of every month. This is not available as of now from GUI. Is there any script to cover this?
Actually, you can do this through the GUI. You can have multiple schedules assigned to a specific job. Just create a schedule that runs on the 15th and then another that runs on the 30th. On the appropriate days the job will execute. Reference:
https://www.mssqltips.com/sqlservertip/2139/sql-server-agent-job-management/. Look under the *"Schedules"* section for an example. Hope that helps!
18 People are following this question.
