SQL Server Performance Forum – Threads Archive
Jobs are not runned
Hi all,I am maintaning more than 50 servers. I have configured lot of jobs. Some time the jobs are not running properly. I want a script which shows jobs are not runned in scheduled time. Please help me Thanks
S. Ramesh
What do you mean they are running properly?
Do you get any error or timeout?
Check the job history in this case, if you have that scale of jobs then I suggest to write the log to a file and use that as a source for checkup. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
quote:Originally posted by sramesh
Hi all,
I am maintaning more than 50 servers. I have configured lot of jobs. Some time the jobs are not running properly. I want a script which shows jobs are not runned in scheduled time. Please help me Thanks
S. Ramesh
Sometimes I have noticed that If we restart the server, scheduled jobs are not running until we reschedule it. It is strange that I had this experience sometimes back
Madhivanan
Failing to plan is Planning to fail
I am maintaning more than 50 servers. I have configured lot of jobs. Some time the jobs are not running properly. I want a script which shows jobs are not runned in scheduled time. Please help me Thanks
S. Ramesh
quote:
Sometimes I have noticed that If we restart the server, scheduled jobs are not running until we reschedule it. It is strange that I had this experience sometimes back
Bit strage. I haven’t noticed such kind of a situation. Does it happening for particular server or for any server
—————————————-Sometimes I have noticed that If we restart the server, scheduled jobs are not running until we reschedule it. It is strange that I had this experience sometimes back
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
We have never faced such problem on our SQL 2005 instances, I suggest to review any information from SQLAgent log or SQL Server eror log. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
<<
Bit strage. I haven’t noticed such kind of a situation. Does it happening for particular server or for any server
>>
I didnt know if that happened in one server or any other server Madhivanan Failing to plan is Planning to fail
Other than the following three reason I see anything not to run the jobs…
1. Either sql agent was not running or agent in starting status…
2. Job is not enabled
3. Schedule is not enabled… What is the SQL AGENT log says?
Mohammed U.
I am also maintaining over 50 sql servers, and be responsible for the SQL jobs. To answer auther’s question, in my case, I had a nightly job on each sql instance to send all the jobs status to a dedicated central server, so during the morning time, I only need to browser the central server to check the job failures for all the sql instances. ——————
Bug explorer/finder/seeker/locator
——————
]]>