Description

This command is used to display the job information owned by the user, including completed and running jobs. By default, it will show the task records submitted in the last 7 days, with a maximum of 10,000 records. Users can view the job information under specified computing resources as needed.

Syntax

SHOW JOBS [IN VCLUSTER vc_name] [WHERE <expr>] [LIMIT num];

Parameter Description

• IN VCLUSTER vc_name: (Optional) Specify the name of the computing resource to filter job information under a specific computing resource.
• WHERE <expr>: (Optional) Supports users to filter based on the fields displayed by the SHOW JOBS command. Users can filter the results through expressions to more accurately find the required data.
• LIMIT num: (Optional) Limit the number of job records returned, ranging from 1-10000.

Usage Example

1. View jobs under the test computing resource that are longer than 2 minutes:

SHOW JOBS IN VCLUSTER test WHERE execution_time >interval 2 minute;

2. View all job records under the computing resource "my_vc":

SHOW JOBS IN VCLUSTER my_vc;

3. Limit the number of returned job records to 100:

SHOW JOBS LIMIT 100;

4. View the 50 most recent job records submitted in the last 7 days under the computing resource "my_vc":

SHOW JOBS IN VCLUSTER my_vc LIMIT 50;

Precautions

• Please ensure that the correct computing resource name and limit quantity are filled in when executing commands.
• If the computing resource name is not specified, the system will default to displaying job information under all computing resources.
• Please set the query time range and record quantity reasonably according to actual needs to quickly obtain the required information.