Member Avatar for dfs3000my

Hi,

I am currently trying to develop my system that would send an email reminder to a user when the deadline for a particular matter is approaching. I did a bit of a research online and I realised that I will need to do some sort of a cron job. However, speaking to my mentor, he told me that I could do some sort of a task scheduling in Microsoft SQL Server 2005 that would automatically cause a trigger at a specific time or at a period of time.

I've tried Googling it up but yet, I am left confused and stuck. Can anyone enlighten me with some information regarding this problem that I am facing now? Btw, I am using ASP.NET and MS SQL 2005 Express Edition.

Thanks in advance and really appreciate those who is able to help me.

  • 2 Contributors
  • 5 Replies
  • 129 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for Ramy Mahrous

Look I don't feel it'd be good to send email from SQL Server, + I don't know if Express edition has this feature or not. but try to send on ASP.NET forum http://www.daniweb.com/forums/forum18.html how to solve this task.

Member Avatar for dfs3000my

Hi,

Here's a simple scenario:

Users are required to fill up a certain type of questionnaire which has a deadline that is set by an administrator. Take for example the deadline is 31st January 2009. The system would do a daily task which is to check which questionnaire has not been attempted. It will then send email reminders to those users who have, say 5 more days, till the deadline is approaching.

I have managed to set up my code so that it is able to send mails but the problem that I have is the automated task that the system is required to check everyday. I hope that these information is enough. Thank you very much.

RamyMahrous: The point that I want to know is whether is it possible to do some sort of an automated task just like what I have mentioned in the scenario above.

P/S: I am very new with SQL Server

Member Avatar for Ramy Mahrous

The system would do a daily task which is to check which questionnaire has not been attempted.

You can use ASP.NET cache to make it every 24 hours check the database and if there's just 5 days, send reminder, it's not hard but need you to know some idea about ASP.NET caching so I highly prefer to you send this question in ASP.NET forum, believe me your thread will be solved immediately.

Member Avatar for dfs3000my

Alright, I've created a new thread in the ASP.NET section. Click here to go to that thread.

Member Avatar for Ramy Mahrous

Very nice, and I'll subscribe there to know how to be handled in ASP.NET :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.