February 12, 2009 at 3:38 am
I am having an issue with one step of a job on MS SQL 2005. When the job runs it fails the 3rd step of 7 i have now changed the job to continue on failure.
Upon checking the history to see why the step failed the message i am shown is being truncated so i cannot find out why the step fails. The step runs an SSIS package and if i run it manually it is always successful.
Is there either a way i can get more info from the message or some other way to see the error?
February 12, 2009 at 3:45 am
I think if you go into the job step, and then the advanced tab, and then configure a value for output file e.g. "D:\Logs\MyFailingJob.txt", then the output from the job including errors will also be given in the text file - but it will not be truncated, however long the error message is.
February 12, 2009 at 5:38 am
Thanks for that. I didn't see that option when looking before but i was looking on my local machine not the server, when i logged onto the server i see the option.
February 12, 2009 at 6:15 am
however you need to creat "History clean up task" to clear history else it will there and unless and untill manually deleted it.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply