run_upd_target_state.sh

#!/usr/bin/env bash
set -euo pipefail

# Cron-friendly wrapper for upd_target_state.sql
# Optional env var override:
#   ORA_CONN="/@bcdc_bccollect" (default) or another connect string
# Usage:
#   run_upd_target_state.sh <target> <state>
# Example:
#   run_upd_target_state.sh APP01 YES
#
# Cron example:
# 00 20 * * * /home/oracle/basecare/work/run_upd_target_state.sh "mengers.dk" "NO" >> /home/oracle/basecare/log/misc/upd_target_state.log 2>&1
# 00 05 * * * /home/oracle/basecare/work/run_upd_target_state.sh "mengers.dk" "YES" >> /home/oracle/basecare/log/misc/upd_target_state.log 2>&1


SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
SQL_FILE="$SCRIPT_DIR/upd_target_state.sql"

TARGET="${1:-}"
STATE="${2:-}"

if [[ -z "$TARGET" || -z "$STATE" ]]; then
  echo "Usage: $0 <target> <state>" >&2
  exit 2
fi

ORA_CONN="${ORA_CONN:-/@bcdc_bccollect}"

if ! command -v sqlplus >/dev/null 2>&1; then
  echo "ERROR: sqlplus not found in PATH" >&2
  exit 3
fi

sqlplus -s "$ORA_CONN" @"$SQL_FILE" "$TARGET" "$STATE"