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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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