Can't SQL Monitor distinguish between a job failing and a jo

Posté le : Samedi 07 Octobre 2017 9:49

Hi,

I have several SQL Agent Jobs that need to run on both replicas of an availability group. The first step of these jobs checks to see if it is primary, and if not, it stops itself. SQL Monitor generates a "Job Failing" alert for these even though the job outcome message clearly states "The job was stopped".

Please help.

Thanks!

I did not find the right solution from the Internet.

References:https://forum.red-gate.com/discussion/81885/cant-sql-monitor-distinguish-between-a-job-failing-and-a-job-being-stopped

Brand Launch