My company has an application that accesses a specific database. Part of the functionality is when a User starts the application a read is executed against the DB that checks if certain records (equipment records) have a re-calibration date that falls with 30 days of the current date, an email is sent out to the appropriate parties as an alert letting them know this piece of equipment is coming up for calibration.
I need to be able to automate this process to make this check on a daily basis. Reason being, suppose nobody executes this application for a week (this will never happen), then this particular check will not happen. I was thinking of a background process is would it be better to do this in the database. I'm thinking in the Database would be best but not sure how to go about setting it up.
Bottom line is....I think there is a more efficient way to do this...just not sure what it is!