ESP Workload Automation

  • 1.  DBSP_JOB ( DB Stored procedure) condition coding.

    Posted Nov 27, 2018 11:40 AM

    Hello. I am new to DBSP_JOB wobs and I have a user that wants to have one of their DBSP_JOB to accept a condition code of 20001. I do not see any options in Editor for me to code. Is there a way to set up a DBSP_JOB job to accept a cc=20001 as success?  Thanks



  • 2.  Re: DBSP_JOB ( DB Stored procedure) condition coding.
    Best Answer

    Broadcom Employee
    Posted Nov 28, 2018 09:47 AM

    Hi Harry,

     

    Unfortunately there is no similar statement like EXITCODE for DBSP_JOB. You may post an idea for enhancement request.

     

    As workaround, you may consider use COND on RELEASE statement, like:

    DBSP_JOB AAA

    .....

    RELEASE ADD(BBB) COND(RC(20001))

    ENDJOB

     

    JOB BBB LINK PROCESS /* the successor will force complete AAA*/

    ....

    ESPNOMSG AJ AAA COMPLETE APPL(%ESPAPPL..%ESPAPGEN)

    ENDJOB

     

    Hope this helps,

     

    Lucy



  • 3.  Re: DBSP_JOB ( DB Stored procedure) condition coding.

    Posted Dec 04, 2018 10:31 AM

    That worked perfectly.  Thank you