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.

Syntax

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

>--)--;--------------------------------------------------------><

Usage

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.

Example

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

Copyright© 2019 HCL Technologies Limited