943,713 Members | Top Members by Rank

Web Development > Databases > MS SQL > Task that would cause a Trigger
Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 911
  • MS SQL RSS
Permalink
Dec 31st, 2008
0

Task that would cause a Trigger

Expand Post »
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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
dfs3000my is offline Offline
21 posts
since Dec 2008
Permalink
Dec 31st, 2008
0

Re: Task that would cause a Trigger

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.
Featured Poster
Reputation Points: 480
Solved Threads: 276
Postaholic
Ramy Mahrous is offline Offline
2,189 posts
since Aug 2006
Permalink
Jan 1st, 2009
0

Re: Task that would cause a Trigger

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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
dfs3000my is offline Offline
21 posts
since Dec 2008
Permalink
Jan 2nd, 2009
0

Re: Task that would cause a Trigger

Quote ...
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.
Featured Poster
Reputation Points: 480
Solved Threads: 276
Postaholic
Ramy Mahrous is offline Offline
2,189 posts
since Aug 2006
Permalink
Jan 2nd, 2009
0

Re: Task that would cause a Trigger

Alright, I've created a new thread in the ASP.NET section. Click here to go to that thread.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
dfs3000my is offline Offline
21 posts
since Dec 2008
Permalink
Jan 2nd, 2009
0

Re: Task that would cause a Trigger

Very nice, and I'll subscribe there to know how to be handled in ASP.NET
Featured Poster
Reputation Points: 480
Solved Threads: 276
Postaholic
Ramy Mahrous is offline Offline
2,189 posts
since Aug 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: SQL Server 2005 - Merge Replication
Next Thread in MS SQL Forum Timeline: Help finding cities and states table/procedure!!!





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC