Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kappa02
Yak Posting Veteran
65 Posts |
 Posted - 2013-07-02 : 16:00:35
|
| I notice that my schedule jobs aren't running now, when I look in Enterprise Manager -> Process Info under the command column 18 jobs have Excute And 2 others have Kill/Rollback. I had restarted the Agent but that didn't help. How can I get the schedule jobs to run normal again, do I need to stop and start SQL Server. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-03 : 01:03:23
|
| Did you change anytinhg in server recently? like renaming db etc.See error log for any possible warnings and see what was the last step in jobs which remain in executing step------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
kappa02
Yak Posting Veteran
65 Posts |
Posted - 2013-07-03 : 10:28:33
|
| No changes that I know of was made & I don't see anything in the log which will rase a flag. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-03 : 13:37:22
|
| Are the jobs in disabled state currently? Is the SQL Server agent service running?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
Agent Starting......