HI Chris

Thanks once again for the above.

Not quite sure I understand your point about running this everyday and removing the condition.

the table u_release_schedule will hold all our release for our strata product for the next few years.   I need the scheduled job to check this table for the u_start_date field and then if that matches todays date then run the script and create the new release record.

When the release record is created then it will start a workflow and create multiple tasks etc.

Without the condition in place how would this work? In your example above would this be ran daily?   I was planning on running this out of hours as to avoid any system issues, although to start with this will only create 1 release log roughly once every 6 weeks.   In the future we are likely to have more products following a similar system but this would never lead to a lot of release logs being created at once with the script

Thanks

Sam