Event triggered once a day only.

Results 1 to 2 of 2

Thread: Event triggered once a day only.

  1. #1
    Join Date
    Dec 1969

    Default Event triggered once a day only.

    I have a scheduler that is opened 100's of times each day. It is an .asp page with ties to a SQL 7.0 database. I would like to have it check the first time it is opened each day all scheduled tasks and send an email to the people who are overdue on a project. How can I make this happen only once per day. Any ideas would be greatly appreciated.

  2. #2
    danz Guest

    Default RE: Event triggered once a day only.

    Check for an application variable containing the date the process was last run. If it doesn't exist (the server just booted), create one with the current date. If it exists, compare it with today, and if the dates don't match, run your process, then set the variable to today.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts