triggers

Posted by Vinay_moduga under Sql Server on 10/20/2009 | Views : 1014 | Status : [Member] | Replies : 3
I am developing a web application (college project) in which i have a library module. In this we are charging the students who had not returned the book in the due time.So, my problem is I want to send them a mail intimating about the status of the book they had taken.
This should be done automatically and I don't want to send the mails manually. I want to use triggers for this which automatically fires as the due date is completed. So , please tell me how to write and invoke the trigger when the due date is crossed for a specific student.




Responses

Posted by: Lakhangarg on: 10/20/2009 [Member] [Moderator] Silver

Up
0
Down
Hi Vinay-

I think you need to use either Job scheduler in SQL Server or Window Application for your above mentioned task.

Thanks & Regards
Lakhan Pal Garg


Vinay_moduga, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vinay_moduga on: 10/20/2009 [Member] Starter

Up
0
Down
thanks for instant reply

can u tell me about Job scheduler in SQL Server

Vinay_moduga, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Lakhangarg on: 10/20/2009 [Member] [Moderator] Silver

Up
0
Down
Hi Vinay-

You can Write a SP or Create a page then create a job scheduler from Sql server. in the server edition of SQL Server. there ia one option to create Job Scheduler. create a job from there and follow the instruction there.

Vinay_moduga, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response