ESP - Delete Agent Requests For Users

This removes failed jobs requests after 1 month that users are not cleaning up themselves.

/*
This script will clean up the agent errors that we are not looking
for every day.

Please run in SQLAgent every day.

Created	Steven F Ling	2021-06-22
*/
--select * from agtRequest where status=3;
delete from agtRequest where status=3 
and errordescription like '%email%' 
or errordescription like '%exited%' 
or errordescription like 'The docket number%' 
or errordescription like '%KDG: Error%'
or errordescription like 'A connect%'
or errordescription like '%No available document rules%'
and cast(actiondate as date) <= cast(dateadd(m,-1, getdate()) as date);