View job status
The utility allows you to view list of jobs (operations) performed on a table. It displays whether an operation was successfully completed or not; and start and end time of the operation.
Step
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 the 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
Output
---------------------------------------------------------------------------------------------
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 is displayed in descending order.
