failed-jobs undefined value as array on Microsoft SQL Server 2000 SP4

[trevrobwhite]

I'm hoping your able to help, we've got a few Microsoft SQL Server 2000 SP4 Servers which haven't been upgraded yet, the plugin is crashing with:

Can't use an undefined value as an ARRAY reference at ./check_mssql_health line 4789.

Any ideas or is this old version just not supported any more (I'm sure it worked in the past), SQL queries still work ok.

Thanks in advance.

./check_mssql_health --server 192.168.X.X --username "XXXXX" --password "XXXX" --warning 43200 --critical 86400 --mode=failed-jobs --lookback 10080 --mitigation=0 --commit -v -v -v

Thu Sep 21 11:21:41 2017: SQL: SELECT @@VERSION ARGS: $VAR1 = [];

Thu Sep 21 11:21:41 2017: RESULT: $VAR1 = [ 'Microsoft SQL Server 2000 - 8.00.2282 (Intel X86) Dec 30 2008 02:22:41 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) ' ];

Thu Sep 21 11:21:41 2017: AUTOLOAD Classes::MSSQL::DBI::override_opt

Thu Sep 21 11:21:41 2017: AUTOLOAD Classes::MSSQL::DBI::check_messages

Thu Sep 21 11:21:41 2017: SQL: SELECT SYSTEM_USER ARGS: $VAR1 = [];

Thu Sep 21 11:21:41 2017: RESULT: $VAR1 = [ 'USER' ];

Thu Sep 21 11:21:41 2017: SQL: SELECT @@SERVICENAME ARGS: $VAR1 = [];

Thu Sep 21 11:21:41 2017: RESULT: $VAR1 = [ 'MSSQLSERVER' ];

Thu Sep 21 11:21:41 2017: SQL: SELECT CAST(COALESCE(SERVERPROPERTY('IsHadrEnabled'), 0) as int) ARGS: $VAR1 = [];

Thu Sep 21 11:21:41 2017: RESULT: $VAR1 = [ 0 ];

Thu Sep 21 11:21:41 2017: AUTOLOAD Classes::MSSQL::DBI::analyze_and_check_job_subsystem

Thu Sep 21 11:21:41 2017: $self->{components}->{job_subsystem} = Classes::MSSQL::Component::JobSubsystem->new() Thu Sep 21 11:21:41 2017: AUTOLOAD Classes::MSSQL::DBI::check_job_subsystem

Can't use an undefined value as an ARRAY reference at ./check_mssql_health_orig line 4789.

[jgbuenaventura]

same issue at Microsoft SQL Server 2000 - 8.00.2039 (Intel X86).