Maintenance plan run date wrong
0
votes
0
answers
154
views
Win server 2019 & SQL Server 2017
On Jan 28th, 2022, I setup 3 maintenance plans to backup 3 databases from 3:00AM – 3:40AM. The last one finishes at 3:45AM. For a few weeks I confirmed that I am getting backups every day and then did not check till today **03/17/2022 at about 12:00PM**
Today I happen to notice that the most recent backups of all the databases were dated **03/16/2022.** Both in the backup name as well as Windows File stamp.
03/16/2022 03:44 AM 2,383 Daily_DBNAME_Subplan_1_20220316034417.txt
I then checked the maintenance plan history for each job and not one job was missed or reported a failure since inception, but in each case the most recent job reported had the previous days’ date.
3/16/2022 3:44 Success Daily_DBNAME Subplan_1
I found an unrelated post, wherein the sysadmin had changed the date (month) incorrectly and now all jobs were scheduled to next run a month later. In this case the Dbadmin resolved it by changing the create date to the next run date. But in his case the jobs had stopped running. In my case jobs are running, just showing yesterday's date.
After changing the job create date to 03/18/2022. The following is the result of a query on all jobs. Will update on results.
Daily_DBNAME1.Subplan_1 Daily Every Day 3:00:00 3/18/2022 3:00
Daily_DBNAME2.Subplan_1 Daily Every Day 3:20:00 3/18/2022 3:20
Daily_DBNAME3.Subplan_1 Daily Every Day 3:40:00 3/18/2022 3:40
Does anybody know why?
Asked by Lansend
(1 rep)
Mar 17, 2022, 08:09 PM
Last activity: Mar 17, 2022, 09:45 PM
Last activity: Mar 17, 2022, 09:45 PM