>The only way I have found so far that would be certain that I do not have duplicate record is to create a task with the minimum interval, thus it would run every 15 seconds. That task will simply have a responsibility to create the daily record. If other robots are in need of the daily record and it would not be yet available, that would be from midnight + 15 seconds, I could establish a 15-second wait time with a retry to grab the daily record after, as it would then be created from the new task.
>
>If someone has an alternate design, I would be happy to see if I can use it.
You could create something like a stored procedure whose sole task is to create the record if it doesn't already exist. Then, all the processes that need the record call the SP (i.e. delegate that function to the SP). After it completes the record is guaranteed to exist.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up