Dear all,
After set a cron job i check in /var/log/cron and can see the job ran:
May 19 15:35:01 urac01 crond[6637]: (oracle) CMD (/home/oracle/database_script/lstandby_job/pro_ins_ms_alltransbyday.sh)
But when i check by run it, the job can not run because i still not compile the procedure:
/home/oracle/database_script/lstandby_job/pro_ins_ms_alltransbyday.sh
REPORT_ADMIN.PRO_INS_MS_ALLTRANSBYDAY();
*
ERROR at line 2:
ORA-06550: line 2, column 14:
PLS-00905: object REPORT_ADMIN.PRO_INS_MS_ALLTRANSBYDAY is invalid
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
So, my cron job wont completed successfull, right. Can i know my cron job completed success or not ??
like AIX it have like this : tail -100 /var/adm/cron/log
Cron Job with pid: 18743514 Successful
root : CMD ( /usr/sbin/dumpctrl -k >/dev/null 2>/dev/null ) : PID ( 3932662 ) : Mon May 19 15:55:00 2014
Cron Job with pid: 3932662 Successful
So Thanks