Overriding Job Retention Days

[Rajarajan R]

Hi ,

We have added the RESET_FLOW_RETENTION_DATES job at the end of some chains and the job is getting completed successfully.

We have the set the retention days for the output file as 60 days.

Even though it says 126 rows updated  but we were not able to fetch the History for last 60 days run  from GUI.

Please find the below output for the same.

sqlplus -s @/uc4/appworx/sql/reset_chain_retention_dates A133641575.lissqlplus -s @/uc4/appworx/sql/reset_chain_retention_dates A133641575.lisTesting 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_daysnew   1: update so_print_log set so_delete_date =so_create_date + 60old   4:     WHERE so_chain_id = &chain_id )new   4:     WHERE so_chain_id = 164606895 )
126 rows updated.
no output from RESET_FLOW_RETENTION_DATES

Thanks
Raja



------------------------------
Senior Consultant
Capgemini
------------------------------

[Pat Richards]

how long ago did you include the RESET_FLOW_RETENTION_DATES in the chains ?  if it was less than 60days ago then of course you won't see anything retained for the full 60days

------------------------------
Regards
Pat
------------------------------

[Rajarajan R]

Hi Pat,

It was added in 2018. 

Regards,
Raja

------------------------------
Senior Consultant
Capgemini
------------------------------