search cancel

How can I delete AE Alarms other than the via the WCC interface?

book

Article ID: 41391

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) Workload Automation Agent

Issue/Introduction

Introduction:

On occasion, you may need to mass delete AE Alarms other than via the WCC interface.
This may be because some old Alarms don’t appear in WCC, or you simply need a practical way to mass delete alarms outside of WCC.

Question: 

How can I delete AE Alarms outside of WCC interface?

Answer: 

You can delete AE alarms directly in the AE database. Alarms are stored in the ujo_alarm table.

To delete all alarms you can truncate the ujo_alarm table. This will remove all rows and therefore delete all the alarms.

If you wish to delete alarms older than a certain number of days, you can do the following:

Each row in the ujo_alarm table includes an ALARM_TIME column. The value in this column is written in UNIX/POSIX time. If you run the ‘time0’ command on the AE command line, you will get the current time.

Example:
time0
CAUAJM_I_50096 Current AutoTime(internal): 1461233487

You can run the time0 command to get the UNIX time value for a particular date using ‘time0 –T MM/DD/YYYY’.

Example:
time0 -T 03/21/2016
CAUAJM_I_50099 Autotime(internal): 1458543600

Once you have the UNIX time value you want, you can use this to delete alarms from the ujo_alarm table older than that date.

Example:
delete from ujo_alarm where alarm_time<1458543600;

 

Once these rows have been deleted, the alarms will have been removed completely.

Environment

Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Component: