Douglas Johnston
My feedback
5 results found
-
13 votesDouglas Johnston
shared this idea
·
-
6 votesDouglas Johnston
shared this idea
·
-
3 votes
An error occurred while saving the comment Douglas Johnston
shared this idea
·
-
25 votes
Daniel Rothig
responded
We like that idea – if it gains traction, we’ll prioritise it more
Douglas Johnston
supported this idea
·
-
36 votes
An error occurred while saving the comment Douglas Johnston
commented
I have an example too that doesn't really fit into this ... we have a SQL Agent job that does backups of the various databases. However, the backups performed vary based on an internal scheduling mechanism that decides if the database should do a full, diff or tlog backup. For example, if we do something like truncate a log file, it may decide to do a FULL to renew the log chain, or it may decide that every 30 mins it will do TLOG but every 4 hours will do a DIFF. The different durations are wildly different, which triggers that alert every time it changes.
I'd prefer to filter the job name out in a similar way to the long running query alert, or maybe define different windows of variability per job name. Difficult one to design, this one ... I don't envy you :-)
Douglas Johnston
supported this idea
·
Actually ... I can see that you can configure the alerts at each level, so you can change the notifications, so I think that is off the table. HOWEVER, I realized that what I think I wanted to say is covered in another ticket - I want ALL notification channels to be available to ALL alerts. I mentioned in another comment that having the notifications as a plugin framework would have been a great thing, as I would then just be able to select each channel on each alert at each group/server ... regardless of the alert type itself.
You can probably reject this ticket as denied if you like, as the functionality is available, and another suggestion covers what I want.