Aveti un log pentru fiecare job (How to: View the Job History (SQL Server Management Studio). Ce apare in log-ul jobului care pica?
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro