These definition can be placed in their own file or added to

[rkennedy]

After chaning all the files to chmod 755 I get this as the output

Code: Select all

Usage: java [-options] class [args...]
           (to execute a class)
   or  java [-options] -jar jarfile [args...]
           (to execute a jar file)
where options include:
    -d32          use a 32-bit data model if available
    -d64          use a 64-bit data model if available
    -client       to select the "client" VM
    -server       to select the "server" VM
    -hotspot      is a synonym for the "client" VM  [deprecated]
                  The default VM is client.

    -cp <class search path of directories and zip/jar files>
    -classpath <class search path of directories and zip/jar files>
                  A : separated list of directories, JAR archives,
                  and ZIP archives to search for class files.
    -D<name>=<value>
                  set a system property
    -verbose:[class|gc|jni]
                  enable verbose output
    -version      print product version and exit
    -version:<value>
                  require the specified version to run
    -showversion  print product version and continue
    -jre-restrict-search | -no-jre-restrict-search
                  include/exclude user private JREs in the version search
    -? -help      print this help message
    -X            print help on non-standard options
    -ea[:<packagename>...|:<classname>]
    -enableassertions[:<packagename>...|:<classname>]
                  enable assertions with specified granularity
    -da[:<packagename>...|:<classname>]
    -disableassertions[:<packagename>...|:<classname>]
                  disable assertions with specified granularity
    -esa | -enablesystemassertions
                  enable system assertions
    -dsa | -disablesystemassertions
                  disable system assertions
    -agentlib:<libname>[=<options>]
                  load native agent library <libname>, e.g. -agentlib:hprof
                  see also, -agentlib:jdwp=help and -agentlib:hprof=help
    -agentpath:<pathname>[=<options>]
                  load native agent library by full pathname
    -javaagent:<jarpath>[=<options>]
                  load Java programming language agent, see java.lang.instrument
    -splash:<imagepath>
                  show splash screen with specified image
See http://www.oracle.com/technetwork/java/javase/documentation/index.html for more details.
./check_sqljob.sh: line 42: /usr/local/nagios/libexec/SqlJobMon.class: cannot execute binary file
UNKNOWN:

Good - looks like Java is installed. Can you provide an example of where you're seeing this error? What is the input?

[bmurtha]

I'm invoking it from the command line this way:

"check_sqljob -H 10.70.5.45 -u sa -p s22css"

[ssax]

Please unzip the modified one, run it again with it, and then post the full output.

check_sqljob.zip

(753 Bytes) Downloaded 267 times

Thank you

[bmurtha]

Hi Ssax,

It seems to work, what I got was <a href=/nagios/sqllog/10.32.35.180-2016-03-11.html target=main> CRITICAL: Number of Jobs Failed:5|count=5</a>

Thank you,

I just need to setup the command and service calls now.

Regards,
Bryan

[bmurtha]

One problem, When I actually went to /usr/local/nagios/sqllog/ there was nothing in that directory.

[bmurtha]

I give up, I'm going to use a simple python script that does the same thing, thanks for all of your help. But it's like trying to make a pig fly at this point.

Regards,
Bryan

[rkennedy]

Did you end up getting this figured out with your python script, or do you need our assistance further?

[bmurtha]

I got the python script working I think,
CRITICAL - Number of failed jobs: 3 - Failed Jobs: BondsInfo last run at 03/14/2016 13:00:00, Websense_IBT_DRIVER__newlogdb last run at 03/14/2016 02:00:00, Websense_Maintenance_Job__newlogdb last run at 03/14/2016 01:00:00
Pretty certain it's ok if I invoke it from the command line everything seems ok, just wondering how do I setup the service and command files to invoke it from the Nagios scheduler? I got the python script from here: https://github.com/jetole/MSSQL-Job-History
He doesn't give an example of the command or service files. I'm trying to figure out what they should look like and where should I place them.

Regards,
Bryan

[rkennedy]

Got it, figuring out the service and command definition shouldn't be too dificult. What is the full command you're entering to receive that result?

[bmurtha]

./check_mssql_job_history.py -H msqlHost -U mssqlUser -P mssqlPassword