January 30, 2007 at 10:38 am
I would like to know on how to create an additional log on a server to capture the error messages when the Reindex job fails.
There is a DTS package that runs every week and it is reindexing 3 databases. The job fails on one of the databases. I would like to get the failed error message in a log file. Could anyone let me know on how to create this log to capture error information?
Thank you.
January 30, 2007 at 12:13 pm
you can write the job-step-output to a txt-file (edit jobstep-properties \ advanced). Maybe that already gives you the info you need.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply