PostgreSQL

Below is a patch to make the script working with a PostgreSQL backend, and a quick-fix for instances where query returns 0E0:

+ my $dsn = “DBI:Pg:database=$sqlDB;host=localhost”;
+ $sql_query = “SELECT SUM(JobErrors) AS errors, COUNT(*) AS count, Job.JobId, Job.JobStatus, Log.LogText
+ FROM Job LEFT JOIN Log on Job.JobId = Log.JobId
+ WHERE (Name=’$opt_job’) AND (JobStatus=’T’) AND (EndTime IS NOT NULL)
+ AND ((EndTime = ‘$date_stop’))
+ GROUP BY Job.JobId, Job.JobStatus, Log.LogText;”;
– my @job_stats = sql_exec();
+ my $sth = $dbh->prepare($sql_query);
+ my $rv = $sth->execute() or die “Error executing query: ‘$sql_query’: $DBI::errstrn”;
+ if ($rv fetchrow_array();
+ $errors = $job_stats[0];
+ $count = $job_stats[1];
+ $jobid = $job_stats[2];
+ $joblog = $job_stats[3];
+ }