View job history
The job history allows you to see which operations have been performed on a table, whether the operation was successfully completed, and when the operation was initiated.
Prerequisite
The pdbctl utility must be installed. Refer to pdbctl utility documents for details.
Steps
To get list and status of jobs performed on the table, run the following command:
Flags description
The following table describes the flags and parameters associated with this command.
Flag | Data Type | Description |
---|---|---|
-a | string | Database alias associated with the database user. |
-h | Flag to view help for getjoblist command. | |
-n | string | Number of jobs to be listed. Default value is 2147483647 |
-t | string | Table name. This is an optional parameter. |
-- verbose | Print verbose logs. |
Example
The following command displays the job status for the table CUSTOMERS
.
The output is:
Here, the status of jobs in descending order is displayed.