Delete alerts automatically

book

Article ID: 111221

calendar_today

Updated On:

Products

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

Issue/Introduction



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

Resolution

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: 

Delete from MON_EVENT;

Please refer the following document for " How to run SQL queries on the Derby Database for WCC"

https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=39384