When do scheduled jobs run?
Versions:
n/a,
FAQ number:
102,
Old FAQ number: 1052
Q: When do scheduled jobs run?
A:
Scheduled jobs in 4.11 and earlier
In version 4.11 and earlier you can examine scheduled jobs by executing the following SQL statement in the database:
select * from tblScheduledItem
The NextExec column shows the next execution time for the jobs.
The LastExec column shows when the jobs were last run.
All datetime fields are in local server time.
Scheduled jobs in 4.20 and later
In version 4.20 and later you can change execution time for scheduled jobs in the admin mode. The time when a new job setting is saved is the base for future jobs. For example, if you configure subscriptions to run once every day and save the setting at 10:41, the job will run at 10:41 every day from now on.
If you need to examine the jobs in the database you can execute the same SQL query as already stated in the "4.11 and earlier" section above. The only difference is that instead of local server time all datetime fields are UDTs.