Friday, February 24, 2012

DTL job error log details -- sql server 2000

Hi
In job history for a DTS job I get percent complete and not futher details
when the job fails. There is no log written anywhere.
How to debug such issues?
Tks
MangeshYou can try by clicking 'Show Step details' in top right corner of the job
history section. That will show you step wise details of the result
execution. As far as logging is concerned, you can log each step's details in
a directory of your choice. This can be done while you are creating the job
steps.
ReportFAQGuy
"Mangesh Deshpande" wrote:
> Hi
> In job history for a DTS job I get percent complete and not futher details
> when the job fails. There is no log written anywhere.
> How to debug such issues?
> Tks
> Mangesh

No comments:

Post a Comment