Re: SQL errors, trapping in Server Agent
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 28 Nov 2005 22:50:20 +0000 (UTC)
Matik (marzec@xxxxxxxxxxxx) 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@xxxxxxxxxxxxx
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
.
- Follow-Ups:
- Re: SQL errors, trapping in Server Agent
- From: Matik
- Re: SQL errors, trapping in Server Agent
- References:
- SQL errors, trapping in Server Agent
- From: Matik
- SQL errors, trapping in Server Agent
- Prev by Date: Re: Select into / Linked Server / Missing IDENTITY attribute
- Next by Date: Re: Bulk Import with header in text file
- Previous by thread: SQL errors, trapping in Server Agent
- Next by thread: Re: SQL errors, trapping in Server Agent
- Index(es):
Relevant Pages
|
|
