Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

NCM Scheduled job alerting

Hi All

The scenario we had, One of our NCM Config Jobs did not process correctly so we missed a few days of no config backups.

I am looking to create an alert when any of the jobs we have enabled does not have a status of scheduled ( as these only run overnight if i check mid-morning if all the jobs processed correctly they will be sitting at scheduled, if it has got stuck it normally sits on running or post processing)

I have found the table for this and does return the jobs not in scheduled state

SELECT NCMJobID, NCMJobName, Enabled, Status
FROM Cirrus.NCM_NCMJobsView

WHERE NCMJobType = '11'
AND Enabled = 'True'

AND STATUS != '3'

I am having issue getting an alert created, when selecting custom swql query as what i want to report on, i cant find any objects that return this table

Thanks in advance

Find more posts tagged with

Accepted answers

All comments

stuartd

I don't have the answer you are after, but as a suggestion have you tried configuring a custom report using your SWQL, and have that sent on a daily [or whatever] schedule?

fraser-sky

Thanks for the suggestion, we already get emails for the backup jobs and can see if jobs havent run by scanning the emails, i want to remove this manual check part for an automatic alert