1.This is a cronjob execute every 10 mins.
2.Every time will select status is new or wait records.(not open ticket can be priority again)
3.Using Alert Name+Short Desc as key and group by key get last record.Other record set states as ignore.
Select now -inserted > delay threshold(by tier) record sort by inserted asc. Get top n record by each remaining tier quota (tier pool quota - db this windows done and processing counts)
5.All row from steps 4 sort by tier, inserted give ticket order and set status as wait.
1.This is a cronjob execute every 10 mins. 2.Every time will select status is new or wait records.(not open ticket can be priority again) 3.Using Alert Name+Short Desc as key and group by key get last record.Other record set states as ignore.