June 21, 2017 at 3:56 am
Hi Experts,
Facing an issue with SQL Server maintenance jobs , all the jobs are failing after running 60-80 mins with below error.
There are no other log errors to troubleshoot further , all the SQL jobs are scheduled at different interval.
Could you please provide your thoughts/comments to troubleshoot the issue.
June 21, 2017 at 4:00 am
Somebody or something has stopped the jobs, either through the GUI or with an sp_stop_job command. Did this happen just once, or does it happen regularly?
John
June 21, 2017 at 6:33 am
It sure sounds like direct intervention by a person. However, do you have a monitoring tool of some kind that has the capacity to interfere with long running jobs?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 21, 2017 at 9:29 pm
Thanks for your reply.
These issues are occurring daily .
Might be the monitoring tool setting about long running queries is the cause , will investigate on that point.
I will post the progress.
June 27, 2017 at 8:35 pm
Sounds like a dangerous setting !
I wrote a query that alerts me if jobs run X% longer than average, but no action is taken, just an email alert.
"...Might be the monitoring tool setting about long running queries is the cause..."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply