Report mail alert
#!/bin/bash # Define database credentials DB_USER="your_user" DB_PASS="your_password" DB_SID="your_db" # Email Configuration EMAIL_TO="recipient@example.com" EMAIL_SUBJECT="OEM Target Report - $(date +%Y-%m-%d)" REPORT_FILE="oem_target_report_$(date +%Y%m%d).txt" # Function to execute SQL query and format output run_query() { SECTION_TITLE="$1" QUERY="$2" echo "=============================================" >> "$REPORT_FILE" echo "SECTION: $SECTION_TITLE" >> "$REPORT_FILE" echo "=============================================" >> "$REPORT_FILE" sqlplus -s "$DB_USER/$DB_PASS@$DB_SID" <<EOF >> "$REPORT_FILE" SET PAGESIZE 500 SET LINESIZE 200 SET HEADING ON SET FEEDBACK OFF SET TRIMSPOOL ON COLUMN "TARGET NAME" FORMAT A30 COLUMN "TARGET TYPE" FORMAT A20 COLUMN ...