AppWorx, Dollar Universe and Sysload Community

  • Private Community

  • 1.  How to override the default 7 day log retention for job output files.

    Posted Feb 15, 2017 07:33 PM

    Jobs run in Applications Manager generate output files that are retained for 7 days by default. Administrators of Applications manager may wish to adjust the default settings to accommodate disk storage needs or other similar requirements.

    For Specific Jobs:

    1. Edit the job.

    2. Select the "Output" tab.

    3. Edit the "Retention Days" field.

    For Process Flows:

    1. Add the RESET_FLOW_RETENTION_DATES component at the end of the chain.

    2. Edit the Retention Days prompt for the RESET_FLOW_RETENTION_DATES component.

    Notes:

    RESET_FLOW_RETENTION_DATES may need to be imported.



  • 2.  How to override the default 7 day log retention for job output files.

    Posted Apr 04, 2017 03:53 PM
    The RESET_FLOW_RETENTION_DATES job is included in an import file named reset_chain_retention_dates.exp. 


  • 3.  Re: How to override the default 7 day log retention for job output files.

    Posted Oct 24, 2018 08:09 AM

    Hi,

     

    From where should i get this  reset_chain_retention_dates.exp file?

     



  • 4.  Re: How to override the default 7 day log retention for job output files.

    Broadcom Employee
    Posted Oct 24, 2018 10:48 AM

    Hello,

     

    The reset_chain_retention_dates.exp may be found in the $AW_HOME/import directory. If you need a refresher on how to import jobs please review the following section of our online documentation: Opening Imports and Mapping Objects

     

    Thanks,

    Cory



  • 5.  Re: How to override the default 7 day log retention for job output files.

    Posted Oct 25, 2018 04:03 AM

    Hi Cory,

     

    Able to locate the exp file. Thanks a lot .

     

    Regards,

    Raja



  • 6.  Re: How to override the default 7 day log retention for job output files.

    Posted Dec 04, 2018 06:35 AM

    Hi ,

     

    I have added the RESET_FLOW_RETENTION_DATES to the end of chain which i need to override the default retention. But in the out file file it shows 0 rows updated as shown :

     


    starting sqlp Tuesday, December 4, 2018 06:27:09 AM EST
    sqlplus -s @/uc4/appworx/sql/reset_chain_retention_dates A7725808.lis
    Testing DB connect
    $Date: 2014-07-18 15:56:38 -0700 (Fri, 18 Jul 2014) $ $Author: mcarkeek $ $Rev: 28038 $
    old 1: update so_print_log set so_delete_date =so_create_date + &retention_days
    new 1: update so_print_log set so_delete_date =so_create_date + 90
    old 4: WHERE so_chain_id = &chain_id )
    new 4: WHERE so_chain_id = 16452532 )

    0 rows updated.

    no output from RESET_FLOW_RETENTION_DATES
    exiting sqlp Tuesday, December 4, 2018 06:27:10 AM EST
    *****************************
    * Finished on Tuesday, December 4, 2018 06:27:10 AM EST with status FINISHED (FINISHED)

     

    Could you please let me know if i missed something here?

     

    Regards,

    Rajarajan