Failed Scheduled Job
Failed Scheduled Job
(OP)
I have dozens of jobs that run overnight to pull back data from a few separate databases.
They have been running for a few years, with very little trouble at all. They always succeed.
Now suddenly, last night one of the jobs failed. Only one job. How can this suddenly happen? I ran the DTS package manually and it worked fine.
The error message just says
"The job failed. The Job was invoked by Schedule 50 (Auto_Daily_Table_Backups). The last step to run was step 1 (Auto_Daily_Table_Backups)."
They have been running for a few years, with very little trouble at all. They always succeed.
Now suddenly, last night one of the jobs failed. Only one job. How can this suddenly happen? I ran the DTS package manually and it worked fine.
The error message just says
"The job failed. The Job was invoked by Schedule 50 (Auto_Daily_Table_Backups). The last step to run was step 1 (Auto_Daily_Table_Backups)."
RE: Failed Scheduled Job
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)
My Blog