Run a Statement or Script in the Background

1. In the SQL Worksheet, enter a SQL statement in the editor pane.
2. Click the arrow next to Run Statement and select Run in background.
3. In the Run in Background panel, specify the following information:

   • Execution name: Enter a name for the execution.

   • Preferred results format, Compartment and Preferred bucket: If you have already configured these values in Preferences, they are populated automatically.
4. Click Run.

   The execution appears on the Background Executions tab.

   Note
   
   Each background execution creates a unique folder in Object Storage. The folder name includes the execution name, a timestamp, and a unique identifier to prevent naming conflicts.

Run a Script in the Background

Running a script in the background follows the same process as running a statement.

To run a script:

1. Enter the script in the SQL Worksheet.
2. Click the arrow next to Run Script and select Run Script in Background.
3. Provide the execution details and click Run.

For databases that support the Multilingual Engine (MLE), you can select either SQL or JavaScript before running the script.