December 23, 2009 at 9:17 am
What is the best way to find the error, why the job is failed?
December 23, 2009 at 9:20 am
The Job execute the DTS package on daily basis, it failed with Process EXit code 1
December 23, 2009 at 10:29 am
If it's the package that's failing, enable package logging by opening the package in DTS Designer, open package properties and go to the Logging tab. You can log to SQL Server or to a file.
Check the log after the next failure.
Greg
December 23, 2009 at 11:24 am
Greg, after logging ON, where exactly i need to find the Log to look for error in sql server.
December 23, 2009 at 11:35 am
sureshdeenu (12/23/2009)
Greg, after logging ON, where exactly i need to find the Log to look for error in sql server.
You would be setting your DTS to write it's error log either to SQL server or to a text file. In either case, you will be specifying the destination (and path if you specify file). Greg wasn't referring to logging onto the server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply