script to change the schedule of a job, it needs to find the schedule associated with the job
0
votes
2
answers
373
views
using Ola's backup strategy ,
there is a job
databaseBackup - system databases full, as you can see on the picture below.
this job is scheduled to run once a week, on a sunday morning.
that is all good, has been running for a while.
Now I need to change it to run every day.
that works fine using ssms, scripting the change and applying it.
however, as I need to get this done in dozens of servers, I will need a script that finds out what is the schedule, and change it and re-apply it to the job
I have not achieved it but I wonder if someone has already done that.

Asked by Marcello Miorelli
(17274 rep)
Aug 16, 2024, 08:47 PM
Last activity: Aug 19, 2024, 11:00 PM
Last activity: Aug 19, 2024, 11:00 PM