Stored Procedure

  • Execute the stored procedure according to the selected DataSource.

Drag from the toolbar PNG task node into the canvas, as shown in the figure below:

Stored Procedure - 图2

Task Parameters

ParameterDescription
Node NameSet the name of the task. Node names within a workflow definition are unique.
Run flagIndicates whether the node can be scheduled normally. If it is not necessary to execute, you can turn on the prohibiting execution switch.
DescriptionDescribes the function of this node.
Task priorityWhen the number of worker threads is insufficient, they are executed in order from high to low according to the priority, and they are executed according to the first-in, first-out principle when the priority is the same.
Worker groupThe task is assigned to the machines in the worker group for execution. If Default is selected, a worker machine will be randomly selected for execution.
Task group nameThe group in Resources, if not configured, it will not be used.
Environment NameConfigure the environment in which to run the script.
Number of failed retriesThe number of times the task is resubmitted after failure. It supports drop-down and manual filling.
Failure Retry IntervalThe time interval for resubmitting the task if the task fails. It supports drop-down and manual filling.
Timeout alarmCheck Timeout Alarm and Timeout Failure. When the task exceeds the “timeout duration”, an alarm email will be sent and the task execution will fail.
DataSourceThe DataSource type of the stored procedure supports MySQL and POSTGRESQL, select the corresponding DataSource.
MethodThe method name of the stored procedure.
Custom parametersThe custom parameter types of the stored procedure support IN and OUT, and the data types support: VARCHAR, INTEGER, LONG, FLOAT, DOUBLE, DATE, TIME, TIMESTAMP and BOOLEAN.
Predecessor taskSelecting the predecessor task of the current task will set the selected predecessor task as the upstream of the current task.