Editing a SQL Task

• Console
• CLI
• API

• 1. Open the project or folder that contains the task that you want to edit.

     For the steps to open the details page of a project or folder, see Viewing the Details of a Project or Viewing the Details of a Folder.

  2. On the project or folder details page, click Tasks.
  3. In the tasks list, select View details from the Actions menu () of the task.
  4. 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.

  5. Save periodically while you work by clicking 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.

  6. When you finish editing the task, click 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.