SQL to activate/deactivate schedules

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Customers may request SQL to deactivate or reactivate their schedules.
 

Environment

Release:
Component: APPMGR

Resolution

To set all active schedules to inactive:

SQL> update aw_module_sched set aw_active='N';
SQL> commit;

To set all inactive schedules to active:

SQL> update aw_module_sched set aw_active='Y';
SQL> commit;

NOTE this will update ALL schedules including naturally inactive schedules. To leave naturally inactive schedules intact, the below sql can be used because AM considers a schedule inactive if aw_active does not equal a Y value. All other values including N is considered inactive:

SQL> update aw_module_sched set aw_active='Z' where aw_active=Y;
SQL> commit;

To set all inactive schedules to active:

SQL> update aw_module_sched set aw_active='Y' where aw_active='Z';
SQL> commit;