I'm trying to understand possible reasons why this scheduled agent is not working. I have it scheduled to run every hour. I have visually verified that there are documents in the database that meet the criteria. This doclink should be sent to the users shown when today is one day past the due date.
The only relevant field is DueDate
SELECT Form = "Issues" & (@Now - DueDate > 84600);
@MailSend("John Smith" : "Anita Jones" ;"";"";"Unresolved Past Due Issue: "; "This issue is now 1 day past due.";"";[IncludeDoclink])
Any help is appreciated. Thanks!