June 12, 2002 at 5:08 am
hi,
one of the jobs (log-reader agent) is displaying the 'error icon' but the log-reader is running correctly. we had an unexpected shutdown a few days ago after which the agent reported an error. what i do not understand is why is it still reporting that error run status? is there any way to set this right? i already deleted all of the job-history but that didn't help. i want to try stop and restart the job but i'm not sure if this will affect the (transactional) replication? i would be grateful for any advice, thank you.
kerstin
June 12, 2002 at 5:15 am
It's behaving correctly. The job status won't change until the log reader completes, so it will continue to show as failed until the next time you stop/start the job. Doing so now will not hurt anything. All transactions stay in the log until cleared by the log reader, so the worst that happens is a min or so of transactions pile up.
Andy
June 12, 2002 at 5:51 am
Andy is right, the icon only represents the last run comoletetion state. So when it fails it will turn red, but a running log-reader will never change the icon so it has not effect on the process. If you stop the process it will report last run success and the icon wil change. Restart it and will remain that way until another failure, at which time the icon is red and it will be running again. The key is the icon is based on last run completetion not current run state.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 13, 2002 at 12:45 am
thank you for your reply - i have folowed your advice and stopped/restarted the job and as there was no error - the icon is signalling 'ok'. i still think that this is very confusing as microsoft clearly stated that the icon is presenting the run-status. when everything is running smoothly - no matter how the job history looks like - i would expect it to display this.
kerstin
June 13, 2002 at 4:51 am
Glad we could help.
Antares - comoletetion?
Andy
June 13, 2002 at 5:37 am
quote:
comoletetion
Yeah, it is one of those technical terms that yells, wish I had a spell checker built into this box. Of course had I had one the word have been different more like, completion.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply