February 6, 2015 at 5:33 am
Hi all
We run some reports that check for failed and cancelled jobs. One job that is coming up is for a Distribution Agent job for replication.
If I stop the job it gets a last run outcome status of cancelled. Ideally I would like this to be succeeded. Is this possible or should I just filter it out on the report? (not what I want to do ideally)
Thanks
February 6, 2015 at 5:56 am
What do you want to do if the result is Cancelled - show Succeeded, or show the most recent non-Cancelled outcome?
John
February 6, 2015 at 5:58 am
Really I want a graceful way to stop the continous distribution job such that the last outcome shows succeeded.
February 6, 2015 at 6:01 am
You want running a report to cause a job to stop? Not something I'd recommend, but if you want to do it, just put an sp_stop_job command at the top of your script.
John
February 6, 2015 at 6:35 am
Sorry maybe I am not being clear.
If you stop a continuous replication job its last outcome status is cancelled. I want a way for it to have a status of succeeded so that it doesn't appear as an issue in our reports.
February 6, 2015 at 7:01 am
Oh, I see. I'm afraid there's no way of doing that, as far as I know.
John
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply