How to schedule a script to run

[infinitizon]

Hi all,

I dont know if this is the right forum, however, I have a website on which users can schedule to send a message at a later time.
For example, a user logs in to the site and decides to send his message by 6:30pm; he enters the time in a box provided and clicks send.

How do I program it such that by 6:30pm, the database (or program or whatever) executes the job.

Any help, please!!!

____________________
Men put up a strong face just to cover their weaknesses...good!
But a smile makes them live longer....
Which would you choose?

Think about it.

 

[simian336]

Since the title of your message is "How to schedule a script to run", I am going to guess that is the way you are leaning.

Store you send time and message details in a table.

Write a script to email messages in the current time frame (either by SQL server or program)

schedule a script to run every few 15 minutes or so

Guessing this is to broad... so follow up with more specific questions.

Simi

 

[infinitizon]

Thanks for the response Simi,

However, I was wondering if this can be done programmatically on mysql and sql server 2008 (samples will suffice). Also, I should be able to send messages either once or periodically as specified by user

____________________
Men put up a strong face just to cover their weaknesses...good!
But a smile makes them live longer....
Which would you choose?

Think about it.