SYS_COPY_JOB_INFO
Use SYS_COPY_JOB_INFO to view messages logged about a COPY JOB.
This view contains information about errors in a COPY JOB that has run.
SYS_COPY_JOB_INFO 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. |
| database_name | character(128) | The name of the database. |
| record_time | timestamp | The time (UTC) when the message was logged. |
| message | chaacter(512) | This message of the logged event for a COPY JOB. |