try right clicking on the job, then selecting "View Job History". Then click the check box to "Show step details", then review the step that failed.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples