• The SQL Agent log file might have some clues. That log is can be found in the following default location c:\mssql\log\sqlagent.out, although on your install it might be somewhere else.

    Gregory Larsen, DBA

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

    Gregory A. Larsen, MVP