Is there a way to ignore specific SQL Agent jobs in AppInsights for SQL? There are certain jobs that run that we just don't care about the status of (provided by 3rd parties and have poor error checking).
Might I suggest disabling the SQL Agent Job Monitor in AppInsight for SQL and instead use the following Application Template for monitoring those SQL Agent Jobs? This template will allow you to specify the specific SQL Agent Job you're interested in monitoring.
You can exclude them from alerting but they will continue to report a failed status in the web interface. You can also optionally disable monitoring of SQL agent jobs on a per-SQL instance basis or for all SQL instances via the template if so desired. If these jobs are failing however, my recommendation would be to delete/remote them from the SQL server.
How would you exclude them from alerting? Create separate triggers and alerts? This is where the lack of the ability of writing overrides to AppInsight templates kills us with so many servers.
I agree with this - we're still not monitoring SQL Agent jobs because I don't have the rights needed to change the jobs. If we could exclude, it wouldn't be an issue.
Really tired of the inflexibility. It impossible to control in large environments.
SCOM - not a problem. I can override any job in 12 seconds and be on my merry way.
If you have no ability to disable the SQL Agent Jobs that are failing in your environment, then I would recommend disabling the "SQL Agent Job Info" component.
