Bulk Change Scheduled End Date In Applications Manager

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Is there a way to change end dates in bulk/batch or do we need to update each schedule 1 at a time?

Environment

Release : 9.1+

Component : APPLICATIONS MANAGER

Resolution

There is no way to do it and you must do it one at a time. There is no issue with doing a update on the DB end but as with any manual updates, its recommended that you stop all processes and take a back up of the DB and AM file repository before running updates. If needed, then you can revert to the back up.

 

You can run the below statements (may need to change date values) to get a count of how many schedules have an end date of 12/31/20, as well as the sql to update (may need to change date value as well):

 

SQL> select count (*) from aw_module_sched where aw_sch_end = TO_DATE('2020-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS');

SQL> update aw_module_sched set aw_sch_end = TO_DATE('2040-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS') where aw_sch_end = TO_DATE('2020-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS');
SQL> commit;