Workload Automation

Expand all | Collapse all

Has anyone used %WOB._status in email notification?

Jump to Best Answer
  • 1.  Has anyone used %WOB._status in email notification?

    Posted 01-15-2019 03:06 PM


    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 "


  • 2.  Re: Has anyone used %WOB._status in email notification?
    Best Answer

    Posted 01-15-2019 07:51 PM

    Hi Sharon,

    Currently, the use of the WOB._status symbolic variable is limited to JavaScripts and Alerts so you cannot use it in email notification.



  • 3.  Re: Has anyone used %WOB._status in email notification?

    Posted 01-16-2019 08:16 AM

    Thank you for the confirmation Segun.  I was going crazy trying to make it work.