Stored Procedure send bulk email

Question

0.00/5 (No votes)

See more:

I develop system that monitoring an equipment that has 3 categories which is A , B and C. There are three main status for the equipment which is Offline , Idle and Online . Then i created another website for user who want to receive and email notification for offline equipment based on their selection A B or C when their registered earlier.

I'm using Oracle Database , ASP.Net for development

How to send email to many user that subscribe when equipment change to offline?
Is Stored Procedure is good to use for this one?
Any example can help on?

Posted 3-Dec-15 14:06pm

apert88

Updated 3-Dec-15 19:17pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2015-12-03T19:23:00

Solution 1

So, you can code a console application to send mails and add that as a Windows Task Scheduler.

In the scheduler, at a predefined time of the day or week (or according to your requirements), the code will check the status of those entities and send mails to the registered users.

Makes sense? Revert back with queries, if you have any.

Posted 3-Dec-15 19:23pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

apert88 4-Dec-15 1:36am

is it not like that , When the Equipment change to Offline only then the notification email will send to those who subscribe. sorry my bad english mr Tadit Dash

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 4-Dec-15 1:55am

Okay, then use triggers and send from database. That is a good option.

apert88 4-Dec-15 1:58am

That mean use trigger (Detect if any changed to particular equipment)?
how about sending an email ? how do i gather all email and how do i put some equipment on body email . Any help sample, idea or whatever very appreciated .

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 4-Dec-15 2:18am

Yes inside trigger, you should retrieve the data you need to send as email.

For email sending, refer - Email From Oracle PL/SQL.

apert88 4-Dec-15 2:21am

Thank so Much Mr Tadit

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 4-Dec-15 2:42am

Most welcome buddy. :)