SQL Server 2005 Service Pack 4 Broken Agent Jobs

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Server 2005 Service Pack 4 Broken Agent Jobs

Author

Topic

jcornell
Starting Member

11 Posts

Posted - 2011-07-13 : 05:30:41

Hello

I am in a spot of bother, we installed the new SQL Server 2005 Service Pack 4 GD and now some of the jobs that are run daily are now failing. The jobs do not fail and there is no error message they simply run for hours and do not progress any further, the only way to stop the jobs is to restart the SQL Server Agent service.

Has anyone else had this issue? I am really worried about this as I cannot throubleshoot the errors.

Regards

James

jcornell
Starting Member

11 Posts

Posted - 2011-07-13 : 11:31:23

***Issue Resolved***

I have changed the syntax of the job to resolve the issue from

exec scheduledjob 1,sqlserver,database

to

"C:\Services Server Components\RunScheduledJob" 1,sqlserver,database

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources