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.
Steps
To get list and status of jobs performed on the table, run the following command:
./pdbctl getjoblist -a <database_alias> -t <table_name>
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.
./pdbctl getjoblist -a demo -t CUSTOMERS
The output is:
---------------------------------------------------------------------------------------------
Job ID | Job Type | Job Status | Start Time | End Time
----------------------------------------------------------------------------------------------
136 | delolddata | success | Tue Nov 21 13:32:47 | Tue Nov 21 13:32:48
----------------------------------------------------------------------------------------------
135 | unmigrate | success | Tue Nov 21 13:29:54 | Tue Nov 21 13:29:54
----------------------------------------------------------------------------------------------
134 | rotatekey | success | Tue Nov 21 13:28:06 | Tue Nov 21 13:28:07
----------------------------------------------------------------------------------------------
133 | migrate | success | Tue Nov 21 13:25:10 | Tue Nov 21 13:25:14
-----------------------------------------------------------------------------------------------
Here, the status of jobs in descending order is displayed.
