Hi,
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.
Status: %(WOB._status).%(WOB._lstatus)
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
Status: .
Job Details
State | SUBERROR |
Job Type | NT |
Status | "Command file not found" |
Start Time | Tue 15 Jan 2019 14:00:30 CST |
End Time | Tue 15 Jan 2019 14:00:24 CST |
Agent Name | WSUNT2201 |
Completion Code | 20007 |
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
Job Details
Lstatus | 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 |
Status | "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 " |