If this is a specific example, you can use the Email Log to see all emails sent by SFDC on the day in question to verify it was sent.
You have some other options as well
a) Add a Task to the target object that is created the same time the Email Alert is sent. The Task acts as a proxy for the email with respect to easy logging/verification
b) Enable Enhanced Email . Email body will appear in activity history.
Rather than searching and deleting interview records, you can run a SOQL query where due date is on future date where those interviews have been queued.
Run a DML update operation on the Grant_Report__c
records and because of this update it will re-evaluate the process and previous interviews will be out of the queues and new interviews will be queued.
You can quickly test at your sandbox before moving it to production.
How do I make sure these would be on the new criteria?
Since you are making changes to the process so it will create new version and after updating all the records, new pending and waiting interviews will get created.
You can monitor those upon reaching Setup->Flows and then Paused and Waiting Interviews
.
Here is an example taken from my DE
For more information, refer Monitor Your Processes’ Pending Scheduled Actions
If you still need to delete all pending interviews then write a SOQL query to retrieve records based on InterviewLabel
with other suitable criteria and delete those.
FlowInterview fiObj = [SELECT CurrentElement,Guid,Id,InterviewLabel,IsDeleted,Name
FROM FlowInterview
WHERE InterviewLabel = 'Sent_Email_after_case_creation-1_InterviewLabel' LIMIT 1];
delete fiObj;
Best Answer
Here the formula field to find business days. this might help for your requirement. CASE(MOD( SLAExpirationDate__c - DATE(1985,6,24),7), 0 , CASE( MOD( End_Date__c - SLAExpirationDate__c,7),1,2,2,3,3,4,4,5,5,5,6,5,1), 1 , CASE( MOD( End_Date__c - SLAExpirationDate__c,7),1,2,2,3,3,4,4,4,5,4,6,5,1), 2 , CASE( MOD( End_Date__c - SLAExpirationDate__c,7),1,2,2,3,3,3,4,3,5,4,6,5,1), 3 , CASE( MOD( End_Date__c - SLAExpirationDate__c,7),1,2,2,2,3,2,4,3,5,4,6,5,1), 4 , CASE( MOD( End_Date__c - SLAExpirationDate__c,7),1,1,2,1,3,2,4,3,5,4,6,5,1), 5 , CASE( MOD( End_Date__c - SLAExpirationDate__c,7),1,0,2,1,3,2,4,3,5,4,6,5,0), 6 , CASE( MOD( End_Date__c - SLAExpirationDate__c,7),1,1,2,2,3,3,4,4,5,5,6,5,0), 999) + (FLOOR(( End_Date__c - SLAExpirationDate__c)/7)*5)
Find more info here. https://help.salesforce.com/HTViewSolution?id=000004526