Sent email alert before month from expiry

Question

1.00/5 (1 vote)

See more:

hello, i have table gridview with col license expiry date and i want befor 30 days from expire send to a specific people email , and in email body should have link to redirect the page that have all licenses expiry.

**i am using sql database

What I have tried:

i've searched too long some method using sql agent, Quartz, Windows service and u need to create jobs with scheduled and trigger.

but can some just give me the simplest and best method for my problem and i can't use sql agent because of sql version don't support it and (give me some hint-tips to start with )

or just help me with this and i will be appreciated

Posted 27-Mar-17 3:42am

Member 13044689

Updated 27-Mar-17 3:52am

v2

Add a Solution

Comments

F-ES Sitecore 27-Mar-17 10:39am

People are only going to suggest all of the methods you've already mentioned. There is no magic simple way of doing this people are keeping secret. ASP.net is not suited to scheduled tasks so if you need to implement them it is going to be a lot of work. Quartz.net is probably the simplest way of doing it so maybe focus on finding examples for that.

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)

AnvilRanger · Accepted Answer · 2017-03-27T03:52:00

Solution 1

Simplest and best do not always go together.

The simplest, do it manually. That way there is no code to write at all.

Personally I would look at creating a console app to query your data, do the comparison, create the email, and send it. Then use the Windows Scheduler to schedule the console app to run when you would like it to.

Posted 27-Mar-17 3:52am

AnvilRanger

Comments

Member 13044689 27-Mar-17 10:00am

can u show me sample how can i do it , i mean if u want.

AnvilRanger 27-Mar-17 12:00pm

What part do you need help with? The console app, how to query the db, send an email, or using Windows Scheduler? I will be glad to help but I will not write an application for you for free.

Member 13044689 27-Mar-17 16:20pm

well sir give me your email and let's go talk private as business work