dbachecks icon indicating copy to clipboard operation
dbachecks copied to clipboard

New Check - Agent jobs that aren't set to notify on failure

Open jpomfret opened this issue 7 years ago • 8 comments

Checks that all jobs notify on failure. Ensure jobs aren't failing and going unnoticed.

jpomfret avatar Jan 29 '18 01:01 jpomfret

What are you thinking here?

Making sure that each job has at least one of the following: Email, NetSend, or EventLog set to OnFailure?

Or config settings for each type of notification?

image

Tonyw72 avatar Jan 30 '18 16:01 Tonyw72

I like the idea of confirming it notifies somehow, and then maybe also matches config value if set? I'd also argue that the eventlog isn't a great notification method, I also believe that is set by default when you create the job via T-SQL.

jpomfret avatar Jan 30 '18 18:01 jpomfret

So, something like this ?

image

Tonyw72 avatar Feb 01 '18 00:02 Tonyw72

I think that would be useful. @potatoqualitee what do you think?

jpomfret avatar Feb 01 '18 17:02 jpomfret

Yes 🌮

potatoqualitee avatar Feb 01 '18 17:02 potatoqualitee

Just need the PSFramework to support validation for array config values 😉

https://github.com/PowershellFrameworkCollective/psframework/issues/54

On Feb 1, 2018 12:54 PM, "Chrissy LeMaire" [email protected] wrote:

Yes 🌮

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/potatoqualitee/dbachecks/issues/237#issuecomment-362348702, or mute the thread https://github.com/notifications/unsubscribe-auth/AXHPn2Rv6gVWGZmQb4zuE5mqs8f1RDp9ks5tQfpXgaJpZM4Rv94t .

Tonyw72 avatar Feb 01 '18 20:02 Tonyw72

I was going through issues and I happened to notice that PSFrameWork #54 is marked "Resolved in 0.9.10.23".

ashdar avatar Nov 16 '18 15:11 ashdar

Recently hit this myself at work. I'll generate a quick, dumb PR next weekend if nobody wants to take this on...

shaneis avatar Jan 17 '21 20:01 shaneis