Delete alerts automatically

Document ID : KB000111221
Last Modified Date : 05/09/2018
Show Technical Document Details
Question:
Daily, the operators deletes alerts manually from Dashboard in WCC. We would like a way to delete alerts automatically.
Environment:
WCC (Workload Control Center) 11.3.6
Answer:
AutoSys by default purges alarms from its database after 7 days. This setting is controled by the DBMaint script which includes archive_events statementes which accept 
parameters to define the number of days worth of data to keep. 

Example: 

In the autosys database 
@archive_events -A -n 7 -b 50000 >> %outfile% 
The 7 represents to delete any records older than 7 days. 

If you need to purge the records more immediately... 
You may login to the autosys database(s) and truncate the 
table ujo_alarm. 

Example: 
truncate table ujo_alarm; 

For WCC, much like AutoSys it defaults to purging older information after 7 days. 

If you wish to change that setting, in WCC go to the Configuration tab, select preferences, select Monitoring and click go. 
There you will find the Backend Services section which includes the Alerts Deletion Threshold. 

If you need to purge all the alerts more immediately then you may login to the WCC database and truncate the table MON_EVENT. 

Example: 
truncate table MON_EVENT;