Please Note:

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.

View job status

Step

Flags description

Example

On this page

Suggest A Change