14,494 questions
Hi,
If you restart the SQL server agent service after modifying the schedule, but this is still the case, please try to delete and recreate this job.
sql server job is not running based on schedule
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 61%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Shi, Hui
1
Reputation point
hi all:
I have a very interesting case .
There is a Database Full backup job and it had a schedule to run on a daily basis at 12am. I've changed it to run on a weekly basis but after a few days, I was surprised to find that this job was still running on a day basis instead of weekly basis...
What's more , job history showed this job was invoked by sql service account directly instead of a schedule ID and job running time was not even 12am.. it was not a fixed time .
I just could not figure it out why this job is not running based on schedule I've modified.
Does anyone have this weird thing before?
Cheers
Hui
SQL Server Other
4 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT 6,661 Reputation points2021-02-05T06:47:56.243+00:00 -
Shi, Hui 1 Reputation point
2021-02-06T00:06:58.887+00:00 I can't restart agent service without proper approval.. it's a major prod env.
Sign in to comment -
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2021-02-04T22:45:43.6+00:00 Another job that starts this job with sp_start_job?
-
Shi, Hui 1 Reputation point
2021-02-06T00:06:27.343+00:00 that's really weird... I even disabled this job yesterday but when I checked again today, seems this job went through last night... Again, on the job history , it said invoked by service account instead of any schedule ID.. Gotta be some hidden process that was calling this job in the name of sql service account. Btw, this job is for Ola's Database Full backup .
Cheers
Hui
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tom Phillips 17,771 Reputation points2021-02-06T15:14:59.09+00:00 Something is running sp_start_job and running the job. When this is done, even disabled jobs run.
The simplest answer is to simply rename the job. Then the process calling it will fail, and someone will say "hey why did process xxxx fail".
Sign in to comment -
-
Shi, Hui 1 Reputation point
2021-02-06T00:10:21.907+00:00 is there any way to find out which process called a sql job? this may help find out the hidden process. According to job history, execution start time ometimes is from minutes and even seconds... No normal sql schedule will be scheduled like this.
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
2021-02-06T10:34:06.007+00:00 I can think of two ways to track this down:
- Add a trigger on a suitable table in msdb to log information. Of course, since this a production environment, this is not without risks. If you mess up the trigger, you may wreak havoc with Agent on the instance.
- A trace where you include the event SP:Starting and filter for sp_start_job. Alternatively an X-event session with the module_start event.
But since you said this was with Ola's maintenance solution, I have a theory. I seem to recall that he has a feature that permits you do things in parallel, and he implements this by having multiple jobs. Does this ring a bell?