Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Job Suspended - WHY??? Expand / Collapse
Author
Message
Posted Monday, November 7, 2011 12:00 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, January 11, 2013 12:30 PM
Points: 21, Visits: 344
We had to re-install SQL Server and one of DBA ran a "ATLER DATABASE msdb modfiy file..." to point to the original msdb files, which worked great, but the jobs would not run. I had to create a Credential and a new proxy to repl dist. Once I change the jobs to use these I restarted the agent and started the jobs and they are all running.

Thanks
D
Post #1201629
Posted Friday, October 19, 2012 6:14 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 9:34 AM
Points: 604, Visits: 1,309
Hawkeye_DBA (4/26/2010)
Great post!

Here's the article from Microsoft:

http://support.microsoft.com/kb/914171



Thanks. It's resolved the issue.
Post #1375067
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse