Activity overview
Latest activity by KathrynM
Thanks Russell. I'll get the update in next week [image] / comments
Thanks Russell. I'll get the update in next week
Fantastic, thanks Russell. / comments
Fantastic, thanks Russell.
To keep things clean and simple a seperate alert for cancelled jobs would probably be my preference. / comments
To keep things clean and simple a seperate alert for cancelled jobs would probably be my preference.
So looping back, is this an enhancement or a fix? / comments
So looping back, is this an enhancement or a fix?
We have a lot of jobs that check if they are running on a replica that is running the database in read only mode. If the database is read only, the job is stopped. (Very similar to the primary replica check used by most people within an avialbility group) Some of the jobs are stopping and triggering an alert through SQL Monitor, even though the run_status is a 3, but not all of the jobs are doing this. It seems to be very hit and miss and I can't find any reason why some would fire alerts but others don't. / comments
We have a lot of jobs that check if they are running on a replica that is running the database in read only mode. If the database is read only, the job is stopped. (Very similar to the primary repl...
If it were a case of SQL Monitor alerting to a job that has been stopped all of the time, or none of the time, then I would agree that this is an enhancement. But because the alert only fires some of the time, I'd be more inclined to say this is a fix becuase the functionality that is in place isn't consistent in its behaviour. / comments
If it were a case of SQL Monitor alerting to a job that has been stopped all of the time, or none of the time, then I would agree that this is an enhancement. But because the alert only fires some ...
That's perfect. Thanks for all your help. / comments
That's perfect. Thanks for all your help.
I will use your link and add some feedback, but I was wondering if you had an issue number or something I can use to monitor the progress of this fix? We are monitoring a few availability groups so getting these alerts is causing us a lot of headaches. We have to follow up on the alert in case it is genuine, but it is nearly always a cancelled job rather than a failed job. / comments
I will use your link and add some feedback, but I was wondering if you had an issue number or something I can use to monitor the progress of this fix? We are monitoring a few availability groups so...
I can see a fix went into V9.0.8 (SRP-11786 Getting notifications on Job Failing alerts ended). Is this the fix for this issue? / comments
I can see a fix went into V9.0.8 (SRP-11786 Getting notifications on Job Failing alerts ended). Is this the fix for this issue?