April 1, 2003 at 12:07 pm
I have a scheduled job, that runs a DTS package. The DTS package grabs a text file and appends it to a table. On occasion the other app that creates the text file fails. So the DTS job fails as well. However the job shows as being successfully run. The action on failure it to quit with failure. The job is running under a DBO account. Why is is showing incorrect status? Server: SQL server 2000 SP2, windows 2000 sp3
April 1, 2003 at 12:35 pm
because the jobs executes the DTS package and it success when is executes.
You should let the DTS package to warn you on error
April 2, 2003 at 8:58 am
Open the DTS package right click on package click on properties. Setup up your error handling here. If you need more info create a workflow on error branch and have some centralize error handling reporting what happened and why.
John Zacharkan
John Zacharkan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply