Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Calendar Reminder about event by email !!! HELP

ksustepksustep Posts: 2Member
Hey guys, i need help of how to create a reminder of any upcoming events for my Calendar application which i create using ASP.NET
i would like fo user to get notification right before an event.
please help me.

Comments

  • iwilld0itiwilld0it Posts: 1,134Member
    : Hey guys, i need help of how to create a reminder of any upcoming events for my Calendar application which i create using ASP.NET
    : i would like fo user to get notification right before an event.
    : please help me.
    :

    Well it depends on what database. If you are using SQL Server, you can set up a scheduled job whih is capable of running TSQL script or even VBScript. Most likely you would use the job to execute a VBScript that opens a CDO object and use it to send e-mail to all users that match a database query.
  • ksustepksustep Posts: 2Member

    :
    : Well it depends on what database. If you are using SQL Server, you can set up a scheduled job whih is capable of running TSQL script or even VBScript. Most likely you would use the job to execute a VBScript that opens a CDO object and use it to send e-mail to all users that match a database query.
    :
    i am using SQL database. do you know any VBScript i can use? do you even know anything about SQL trigger, is it possible for me to do it. will it do what i want, and if it will how should i do it? do you know the script?
    thanks for your answer
  • iwilld0itiwilld0it Posts: 1,134Member
    Off hand, I do not know of any VBScript. However, the VBScript will use ADO to open a database connection, create a ADO command, which will execute a SQL command that returns a Recordset of scheduled events. The VBScript will read each record in the recordset. Each record should have a database column with the e-mail address of the person who scheduled the project. You will then create CDO objects (e-mail objects built into Windows) and send a e-mail message to each e-mail address. Of course the body of the e-mail, should contain the detail of the event.

    You want to use a SQL Job not a trigger. A Job runs on a time interval you specify, whereas a trigger runs when either a DELETE, INSERT, or UPDATE SQL statement is run.

    NOTE: The the size of the VBSript is limited within the SQL Job. SO be as concise as possible.
Sign In or Register to comment.