Note that this article applies to Ignite 8.0 and lower. Ignite 8.1 and higher allows alerts to run less often than 10 minutes down to once a minute as the most frequent.

The lowest run frequency allowed in the GUI for an Ignite alert is to have it run once every 10 minutes. Sometimes an alert needs to run more often.Ignite alert information is stored in a table named CON_ALERT and this table can be updated to change the frequency from once every 10 minutes to once a minute, for example.  To do this:

1. Get the exact alert name you want to change:

select id, alertname, frequency from con_alert order by alertname;

2. Update the frequency (this example changes the alert to run once a minute):

update con_alert set frequency = <number_of_minutes> where id = '<id_of_alert>';

3. Restart the Ignite PI Server.  This is necessary because the Ignite Web Client (IWC) is responsible for executing alerts and it caches the alert information.

Note: If you update the alert in the Ignite GUI, the frequency may be set back to 10 minutes. If this happens, you will need to update the alert again following the steps above.