I am trying to use %WOB._status and %WOB._lstatus in the body of the email notifications if a job FAILED or gets a SUBERROR. I can get the lstatus but the status doesn't seem to update. Has anyone else used %WOB._status?
on job's notification - email tab,
body of email - append to default message is checked.
actual email - job failure has status, no lstatus. would expect to see 'command file not found' in body of email.
Job PFMW010001.EDI_LOOKFORNONPROCESSEDFILES of application PFMW010001.341 is in SUBERROR state.
Agent name: WSUNT2201
Completion code(if applied): 20007
Help, I've fallen and can't get up
actual email of job with status and lstatus, note that .lstatus before .lstatus should be status
Job V_DS_USR_PRMSN_ECDW0 of application PAAD501100_DATASEC_REFRESH_UNT.62510 is in FAILED state.
Agent name: DB_UNT_AGENT
Completion code(if applied): 12008
State : FAILED
Status: .java.sql.SQLException: ORA-12008: error in materialized view refresh path ORA-04052: error occurred when looking up remote object SNI.SNI_DS_PRMSN@SNIW0.WORLD ORA-00604: error occurred at recursive SQL level 2 ORA-12541: TNS:no listener ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2809 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3025 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2994 ORA-06512: at line 1
Thank you for the confirmation Segun. I was going crazy trying to make it work.