Jobs Stopped For No Reason

Asked By aldrin richards 60 points N/A Posted on - 04/13/2012

I am having a problem with MS SQL Server 2008 where some of the jobs stopped but I could not find out who or what might be causing it because the server timed-out. I also checked the CPU to see if there is high CPU usage but it seems to be running fine. How can I find out who or what could have stopped some jobs and what are the possible ways I can prevent it from happening again?

• Status: Open
• Question Views: 1024
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Gideon Yasti 15 points N/A #106992

Jobs Stopped For No Reason

Hy

It may happen for run multiple programs in same time. If you run multiple programs in same them then your CPU usage will increase and it may occurs this type of problem which you mentioned above. Sometimes applications or programs are run automatically in computer for auto start up function. You can disable auto start up for all applications of your computer. It will prevent your high CPU usage.

To disable auto startup select start button and then select run option and then write msconfig in that text field. Now press enter and then you will get a new window and then click startup tab form that window. Finally select disable all and then restart your computer.

 

Thanks

About Gideon Yasti

Questions
3

Answers
316

Best Answers
69

• Vote Up 0 Vote Down

• Posted on - 05/15/2012
• Question Category: MS SQL Server