Oracle Cloud Infrastructure Documentation

Editing a SQL Task

Edit a SQL task in a project or folder in Data Integration. You can change any of the configured input parameter values in the associated stored procedure.

    1. On the Tasks page of a project or folder, find the task that you want to edit. If you need help finding the Tasks page in a project or folder, see Listing Tasks.
    2. From the Actions menu (Actions menu) for the task, select View details.
    3. On the SQL task: <task name> page, edit the fields and sections as needed.

      For descriptions of the fields and sections, see Creating a SQL Task.

    4. Save periodically while you work by selecting one of the following buttons:

      • Save: Commits changes since the last save. You can continue editing after saving.

      • Save and close: Commits changes, closes the page, and returns you to the tasks list on the project or folder details page.

      • Save as: Commits changes (since the last save) and saves to a copy instead of overwriting the current task. You can provide a name for the copy and select a different project or folder for the copy, or save the copy in the same project or folder as the existing task.

    5. When you finish editing the task, select Save and close.

  • Use the oci data-integration task update-task-from-sql-task command and required parameters to update a SQL task:

    oci data-integration task update-task-from-sql-task [OPTIONS]

    For a complete list of flags and variable options for CLI commands, see the Command Line Reference.

  • Run the UpdateTask operation with the appropriate resource subtype to update a SQL task.