Keep sending email every week until request has been answered.

Posted on 2011-10-05
Last Modified: 2014-05-13
Once the form is filled out, clicking on the 'Create' Button sends an email request.
How do I automatically resend the same email  again a week later and make it stop sending when the request has been reviewed.  

When reviewer clicks on 'Approved' Button, the form is digitally signed (got this part working), it should stop sending weekly emails.

Hope I'm making myself clear.
Question by:InxsDar
    LVL 142

    Accepted Solution

    you need to put a "send email queue" table into place, and do the sending based on that table.
    the table needs to have the necessary info on what email to send, and a column like NEXT_SEND_DATE  
    this column will be set to "SYSDATE" in the "Create" button click.

    then, a scheduled job (once per hour, for example) will check all those rows in the table that have NEXT_SEND_DATE <= SYSDATE, and do the email sending for those + UPDATE the columns's value to NEXT_SEND_DATE + 7 to "reschedule" for next week

    the "Approve" button will then need to delete this record.

    hope this helps

    Author Comment


    Thanks for the reply!

    Is there a scheduled job in Oracle Apex?
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    I'm not a specialist, so I would refer to:

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    This short article will present "How to import ICS Calendar onto Office 365 Calendar". I was searching for free (or not free) tools to convert ICS to CSV without success. The only tools I found & working well were online tools...this was too hard to…
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
    The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now