Creating a SQL Task
A SQL task in Data Integration is associated with a stored procedure in a database.
The database must be associated with a data asset that's already created in the workspace. To create a data asset, see Creating a Data Asset.
Create a SQL task in a project or folder. Data Integration includes one default project to get you started. To create another project or folder, see Projects and Folders.
In Data Integration, by default you can have simultaneous or parallel task runs of a task at a given time. To disallow concurrent task runs that are initiated manually, select the Disable simultaneous execution of the task checkbox when you create the task. When simultaneous task runs are disallowed, a run request for the task fails if there's already a task run in progress that's in a non-terminal state.
Publish the SQL task to an application in Data Integration before you run the task or schedule the task for running. For publishing information, see Publishing to a Data Integration Application. Use the oci data-integration task create-task-from-sql-task command and required parameters to create a SQL task:
oci data-integration task create-task-from-sql-task [OPTIONS]
For a complete list of flags and variable options for CLI commands, see the Command Line Reference.
Run the CreateTask operation with the appropriate resource subtype to create a SQL task.