We created custom SLA fields, which update according to our SLA requirements. We then added a crontab entry to check for SLA on our 50+ queues as below:
*/1440 * * * * /opt/rt4/bin/rt-crontool --transaction last --search RT::Search::FromSQL --search-arg "(Queue=‘Provisioning - Wholesale’) AND (Status != ‘resolved’) AND (‘CF.{Respond By}’ < ‘30 minutes ago’) AND (‘CF.{Response Time}’ = ‘’) " --action RT::Action::Notify --action-arg Cc --template ‘SLA’
the cron seems to crash our server when left to run…
What would be the best solution to use custom SLA fields as above with cron without overloading the server?