Schedule Job to run based on date/time field on custom table

[Sam Ogden]

Hi all,

I would like to create a custom table called u_release_schedule that will hold date/times of when a new release record will be created.   I was wondering if it is possible to setup a scheduled Script Execution that will run based on the date/time field in the custom table.

The script would then create the record.

The background to this is we have a continuous development that needs a release log creating on a roughly 6 week cycle (this is not exactly 6 weeks everytime due to holidays e.g. it ends up being an 8 week cycle over the Christmas break).   Rather than anyone having to manually create the initial release record I would like the scheduled job to create the initial release, this will then fire the workflow which will then create all the tasks that are required at the correct times.

Any help on the above will be greatly appreciated.

Thanks

Sam

[christopheriron · Accepted solution]

Hi Sam,

You can't set a scheduled job to run on a specific field, what you can do is set it to run daily but then add the conditional field to the scheduled job and set a condition to match the current date to any dates on the table that you're creating.

Kind Regards

[Sam Ogden]

Thanks for the above.  

Does this sound the best approach to what I am trying to achieve?

Still learning the system and want to make sure we are doing things in the appropriate way

Thanks

[christopheriron]

Yep, that sounds perfect, you will just need to set up a template for the record first then set the conditions and you should be fine.

Kind Regards