Knowledge Base

Suspending Scheduled Tasks

Last Modified:
26 Jul 2019
User Level:
Administrator +

Typically, TERMINALFOUR will be configured to automatically publish (and, if required, Transfer) your sites at scheduled intervals. This creates scheduled tasks in the Task Scheduler. To perform testing on the site and prevent an automatic publish or a transfer, it is possible to temporarily suspend the scheduled tasks.

Suspending scheduled tasks requires access to the TERMINALFOUR database.

Disable the Scheduled Tasks

To disable currently active tasks, you will need to run the following query in the TERMINALFOUR database:

UPDATE schedule SET status = 0 WHERE id=x

Replacing the x for the ID of the scheduled task (which can be seen in the Task Scheduler listing).

Then you will need to restart the Task Scheduler.

The tasks will still appear in the Task Scheduler and will not indicate that they are disabled. They should be re-enabled as soon as possible.

Enable the Scheduled Tasks

To re-enable the scheduled tasks, you will need to run the following query in the TERMINALFOUR database:

UPDATE schedule SET status = 1 WHERE id = x

Replacing the x for the ID of the scheduled task (which can be seen in the listing).

Then you will need to restart the Task Scheduler.

Restarting the Task Scheduler

If you modify the database schedule table, changes will not be picked up unless you either restart the application server or restart the task scheduler.

To restart the scheduler, use an amended version of the URL below with your TERMINALFOUR hostname and context: 

http://{your hostname}/{your context}/SiteManager?ctfn=schedule&fnno=100

From v8.3, this url will no longer function. A button will be added to the UI in a future release to re-instate the functionality.

 

Back to top