You need to sign in to do that
Don't have an account?
Venkatesh Mandlem
Batch script to schedule daily batch job for reminder emails
How To schedule a daily batch job which runs daily and sends out reminder mails 24 hours before .
function readOnly(count){ }
You need to sign in to do that
Don't have an account?
Scheduled Apex would be the recommended approach.
You could have a hidden Date field on Account called FieldsLastUpdated__c
Have a workflow that fires each time the record is created or edited, check if the fields you're interested in are updated (using ISCHANGED()) and if they have been updated, set this date to TODAY()
This now signifies that those fields were updated on the Date stamped in the FieldsLastUpdated_c
Have a simple batch class that runs each night, and scans for Account records where FieldsLastUpdated__c < Date.today().addDays(-14) i.e. 2 weeks using the QueryLocator
Now in your execute cycle through these Account and for each create an email for the owner, and the finally bulk send.
Please let me know if this helps
Best Regards
Naga kiran
You can also try the code below which is quite similar
Please let me know if this helps
Best Regards
Naga kiran