Monitoring SQL Server Agent Jobs

[rj-admin2]

Hi,

I'm using NCPA to monitor our Windows SQL server - things such as transactions/sec, database log size etc. What I now want to do is monitor a running SQL Server Agent maintenance job that backups up the database transaction logs every 15mins. I want to know if this job was successful or not. Is this possible in Nagios XI and how do I do it?

TIA.

[lgute]

Hi @rj-admin2,

Thanks for reaching out. This thread may be helpful.

Service Checks are just "jobs" that run various scripts or applications (plugins) to test whether conditions are in a good or bad state, basically. There are plugins available on the Nagios Exchange, Github, etc. Another option is to modify an existing plugin or even write your own.

A quick search gave me these Github plugins:

• https://github.com/mroter/MSSQL-Job-History
• https://github.com/yosbit/nagios-plugins