Failed Scheduled Job

monkeybarfan · Mar 20, 2009

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 · Mar 22, 2009

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Failed Scheduled Job

monkeybarfan

MIS

mrdenny

Programmer

Similar threads

Part and Inventory Search

Sponsor