scheduler argument: Stop or start the scheduler (SQL administration API)

Use the scheduler argument with the admin() or task() function to start or stop the scheduler.


Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--+-"scheduler shutdown"-+----->
                     '-task--'     '-"scheduler start"----'   



Use the scheduler shutdown argument to stop the scheduler and deallocate its resources.

Use the scheduler start argument to start the scheduler.

This function has no equivalent utility command.

You can view the status of the scheduler threads with the onstat -g dbc command.


The following example starts the scheduler after it has been shut down:
EXECUTE FUNCTION task("scheduler start");

Copyright© 2018 HCL Technologies Limited