Sample Header Ad - 728x90

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. enter image description here
Asked by Marcello Miorelli (17274 rep)
Aug 16, 2024, 08:47 PM
Last activity: Aug 19, 2024, 11:00 PM