MSSQL Job Monitoring

The plugin functions as intended but there are some unnecessary features that I would like to disable. Overall the configurability is lacking.

---

I am running core 3.5.1 on SLES 11 SP3 and the HTML ref is not working properly. It gets the info manually but not from service.

Manually -
sudo -u nagios /usr/lib/nagios/plugins/check_sqljob.sh -H -u user -p passwd
OK: Number of Jobs Failed:0|count=0

Nagios run:
usherdbt02;Failed Jobs;OK;SOFT;2; OK: Number of Jobs Failed:0

The link is also bad in Nagios:
http://nagios/nagios/cgi-bin/null/-2013-11-08.html

Any ideas? what am I missing?

---

Very good afternoon my name is Osman Panama writing from the truth I have a little problem, I have set up a nagios 3.2.1 on my system I have all monitoring well but I was asked to configure SQL server 2008 jobs I've seen on the website of nagios some cases but honestly I could not give the matter would like to know is can you give me a step by step that I must put in where and what should I set

thank you very much

---

I can get this plugin to run from a command line all day long under the nagios and root user but when I set it up in nagiosxi and returns unknown every time. What am I missing?

---

Getting this error when running the plugin.

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver not found in gnu.gcj.runtime.SystemClassLoader{urls=[file:/usr/local/nagios/libexec/,file:/usr/local/nagios/libexec/sqljdbc.jar], parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}
at java.net.URLClassLoader.findClass(libgcj.so.10)
at java.lang.ClassLoader.loadClass(libgcj.so.10)
at java.lang.ClassLoader.loadClass(libgcj.so.10)
at java.lang.Class.forName(libgcj.so.10)
at SqlJobMon.main(SqlJobMon.java:97)
UNKNOWN:

---

If you're getting the error

: bad variable nameH

This is because it's a Windows formatted file. Not sure how a Windows formatted bash script came to exist anywhere but there is one in this release. The difference is that Linux and Unix (which includes Mac OSX) use n for newlines in their text files while Windows uses rn for new lines in their text files.

To convert the file to unix format you can use the command fromdos or on some systems, the older command dos2unix.

...or you could try out my much simpler Python check I wrote to do the same thing as this script and more without requiring compiled Java binaries in order to work. It's a simple, single, Python script with no other files combined with it that you can get from either:

http://exchange.nagios.org/directory/Plugins/Databases/SQLServer/MSSQL-Job-History/details

or

https://github.com/jetole/MSSQL-Job-History

Doesn't require Java. Doesn't have Windows line endings, provides more options and gives more detailed reports.

---

Running on Ubuntu:

I can't use this plugin.
I can't run this command:
sh check_sqljob -h

Because this wrote:

: bad variable nameH

Can you help me?

Thanks

---

Hi muthu,
First of all, really thanks for sharing this script with us. I'm trying to rewrite the java source so I can specify a Job name instead of all job names of a MSSQL server.
I'm stuck on some parts of the java source code, mind helping me out? You can contact me on sjorrs[at]gmail.com ofcourse I will share the source after it is working!
Cheers!

---

running command from console plug-in work fine
after service definition plugin go into "unknown" status
Can someone help me????

---

Is it not possible to use windows Auth with this plugin ? we only run our servers with Windows authentication

ps on the current version I had to do dos2ux for the check_sqljob.sh to even run

---

I can't use this plugin.
I can't run this command:
sh check_sqljob -h

Because this wrote:

: bad variable nameH

Can you help me?

thanks

Peter

---

It's a few lines shell script around binary java files hiding the core functionality. Any chance to see the source code? I won't let this connect to my databases and do whatever without having the slightest idea what's inside.

---

This one just works fine..... Hats off!!

---