Hello again, I have a question regarding the Job Scheduler: Scheduled Jobs menu.
Specifically, I want to set two seperate time restrictions to a recurring job.
Currently I can do this. This job will repeat every 30 minutes, from 14D/05M/2024Y at 08:30 to 14D/05M/2024Y at 21:00
Despite the titles being "Start Time" and "End Time", we have discovered that these are actually start dates and end dates.
Essentially, the job will cease to initialise after the "End Time" date, instead of time. It will not start again on the next day at 08:30.
My current understanding is that I cannot schedule a recurring job that starts at 8:30, runs once every 30 minutes, stops at 17:00, then starts again at 8:30 on the next day.
I am testing two workarounds.
- Create a time-check in the operation that is called. It simply compares start\end time SystemParameter or a External Parameter that can be set in the JobActions and compares it to the local time.
- Use Stored Procedures to UPDATE the JOB_SCHEDULE before the job runtime.
- Uses a Stored Procedures to UPDATE the JOB and JOB_SCHEDULE tables, and sets:
- JOB_SCHEDULE.StartTime to 2024-05-14 23:30:00.000 (Placeholder UTC time)
- JOB_SCHEDULE.EndTime to 2024-05-15 09:00:00.000 (Placeholder UTC time)
- JOB.Status = 1 (Scheduled)
- Uses a Stored Procedures to UPDATE the JOB and JOB_SCHEDULE tables, and sets:
Is there any official solution for scheduling a Job like this? We would greatly prefer being able to setup the Job Schedule the normal way, instead of splitting the "schedule" into two different parts/places.
I just want to check in with the community here and make sure my understanding is correct, before going through with a workaround that will raise questions later down the line.
Thanks in advance,
Shiota Azu