batch

#!/bin/bash
 
 
DB_HOST=""
DB_NAME=""
DB_USER=""
DB_PASS=""
 
 
job_list=("name")
 
 
desired_ds=$(date -d "yesterday" '+%Y-%m-%d')
desired_ts="00:00:00"
desired_dts="$desired_ds $desired_ts"
echo "$desired_dts"
 
 
declare -a job_output
 
 
for job_name in "${job_list[@]}"; do
       sql="SELECT bje.EXIT_CODE, bje.CREATE_TIME FROM BATCH_JOB_EXECUTION bje JOIN BATCH_JOB_INSTANCE bji ON bje.JOB_INSTANCE_ID = bji.JOB_INSTANCE_ID WHERE bji.JOB_NAME='$job_name' and bje.CREATE_TIME > '$desired_dts' LIMIT 1;"
    result=$(mysql -h "$DB_HOST" -u "$DB_USER" -p"$DB_PASS" -D "$DB_NAME" -se "$sql")
    if [[ -z "$result" ]]; then
        job_output+=("DID NOT RUN")
    else
        job_output+=("$result")
    fi
 
done
 
 
count=0
for return_value in "${job_output[@]}"; do
    if [[ "$return_value" == "DID NOT RUN" ]]; then
        echo -e "Statistic.${job_list[$count]}: -1\n"
        echo -e "Message.${job_list[$count]}: $return_value\n"
    elif [[ "$return_value" == *"FAILED"* ]]; then
        echo -e "Statistic.${job_list[$count]}: 1\n"
        echo -e "Message.${job_list[$count]}: $return_value\n"
    else
        echo -e "Statistic.${job_list[$count]}: 0\n"
        echo -e "Message.${job_list[$count]}: $return_value\n"
    fi
    ((count++))
done
 
exit 0