New column in jobs for interval (recurrence period), stored proc to update next run time (trigger_time) and test for the stored proc.