Use SYS_COPY_JOB to view details of COPY JOB commands.
This view contains the COPY JOB commands that have been created.
SYS_COPY_JOB is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views.
Table columns
| Column name | Data type | Description |
|---|---|---|
| job_id | bigint | The copy job identifier. |
| job_name | character(128) | The name of the copy job. |
| iam_role | character(128) | The IAM role specified in the COPY statement. |
| job_text | character(256) | The parameters of the COPY statement. |
| is_auto | integer | Indicates whether the COPY JOB is automatically
run by Amazon Redshift. A 1 indicates true, 0
indicates false. |
| on_error_suspend | integer | This information is for internal use only. |
