Posted by Erland Sommarskog on 11/29/05 00:50

Matik (marzec@sauron.xo.pl) writes:
> I've fallow problem. I've a sp called as a job of SA each minute. This
> runs pretty nice, but from time to time, the job is aborted, and I
> don't know why.

When you view job history, there is a check box to include the step
details. This is usually where the error message is hiding.

You can also define an output file for the step.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Bulk Import with header in text file
• Prev in forum: Re: Select into / Linked Server / Missing IDENTITY attribute
• Thread view: Re: SQL errors, trapping in Server Agent

[Reply to this message]