AnsweredAssumed Answered

Has anyone used %WOB._status in email notification?

Question asked by shimaneks on Jan 15, 2019
Latest reply on Jan 16, 2019 by shimaneks


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

Job TypeNT
Status"Command file not found"
Start TimeTue 15 Jan 2019 14:00:30 CST
End TimeTue 15 Jan 2019 14:00:24 CST
Agent NameWSUNT2201
Completion Code20007


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

Lstatusjava.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 "