Oracle 10g: Auto email to be triggered to business team once in every 30 days of lounge rates before expiry date

5 pts.
Tags:
Oracle
Oracle 10g
An auto email to be triggered to the business team once in every 30 days of lounge rates before expiry date? How can I set that up?

Software/Hardware used:
Oracle PL SQL

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    There are several things involved in this problem, and you didn't specify which ones you need help with:

    1) You need to know how to identify the date in which the e-mail should be sent.  If you need help with that, you would need to post the definition of your tables and explain how you determine the desired date, with words.

    2) You need to know how to send e-mail from the database.  If you need help with that, a Google search could help you, because it is not something that can be explained in a couple of paragraphs here, but there are lots of examples on the web.

    3)  You need to know how to "trigger" the action to send the email.  You will most likely need to use the scheduler to run a verification task periodically, which will decide if an e-mail needs to be sent every time it is run.  If you need help with this, let us know the problems you are facing, or ask more specific questions about it.

    Good luck.
    84,310 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: