Check the date database and execute

Question

I have a table in the database that contains the start date and end date. Now I need to have the database checked once at night, checking all the ending dates. if today is the day before the end date, then I can execute a java class that will send an email notification that the membership will expire. I am using oracle and java (jsf) database as development language.

My date stored in the table is in my preferred format, i.e. MM / DD / YYYY.

Thanks,

Answer 1

Schedule a job using DBMS_SCHEDULER to start the PL / SQL procedure at the interval you want. The PL / SQL procedure can call your java method to send an email notification.