Sceduling issue

Hiii,

I have process in which i have to send a mail and depending on the subject say for apache i have to send mail every 5mins and for database every 10mins and subject i am picking from excel

How do i do that using sceduling

Thanks and Regards,
supriya

use last mail sent time and current time difference using time span send the mail if the time span is above 5 min send Apache mail ,if time span is above 10 send database mail and use two different time spans for two different mails

Hii @shyamm

How to find last mail sent time and current time using timespan.

Thanks and Regards,
Supriya

hi @supu123

you can store last mail sent time in the excel at the time of sending mail

you can get the current time by system.DateTime.Now.ToLongTimeString

Regards,
Vamsi Nori

Hii,
How to store last mail sent time in excel at the time of sending mail

Thanks and Regards,
Supriya

store the mail sent time(means system time when you sending the mail)in variable and compare with current time using loop

Create a new column in excel with “sent time” as column name update its value with system.DateTime.Now.ToLongTimeString which is the time of sending mail based on other column condition like row(“subject”).ToString.Equals(“XYZ”). Here XYZ is your subject.