Paul Sturrock wrote:You can just call the relevant system stored procedures I think - from memory it's sp_add_schedule (or something similar) to schedule agent jobs.
So, once I create a schedule, I can assign the schedule to a particular job and alter the interval dynamically using this procedure
sp_update_schedule ???