Re: Scheduled Job Sometimes Error Sometimes Not
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 27 Jul 2005 09:18:58 +0000 (UTC)
Resant (resant_v@xxxxxxxxx) writes:
> I have a scheduled job contain 2 steps. Step 1 is execute DTS Package
> using CmdExec 'DTSRun', step 2 using TSQL to execute just simple query.
> This job execute recurely every day, every 6 hours.
> The problem is, sometimes this job was successfull, but sometimes
> failed with error as below :
>
> ...
> ...
> Process Exit Code -1073741819. The step failed.
>
> Please help me, what the cause of the error?
> Any help would be greatly appreciated.
In View Job History, there is a check box for "Show step details". Check
that box, and you may find some more details.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.
- Follow-Ups:
- Re: Scheduled Job Sometimes Error Sometimes Not
- From: Resant
- Re: Scheduled Job Sometimes Error Sometimes Not
- References:
- Scheduled Job Sometimes Error Sometimes Not
- From: Resant
- Scheduled Job Sometimes Error Sometimes Not
- Prev by Date: Scheduled Job Sometimes Error Sometimes Not
- Next by Date: Re: Anything that you find in SQL object scripts, you can also find them in system tables?
- Previous by thread: Scheduled Job Sometimes Error Sometimes Not
- Next by thread: Re: Scheduled Job Sometimes Error Sometimes Not
- Index(es):
Relevant Pages
|
