Failed Scheduled Job

[monkeybarfan]

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).

 

[mrdenny]

To see what caused the failure you would to have needed to have enabled logging within the DTS package which is disabled by default.

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