UltipaDocs
Try Playground
  • Introduction
    • Overview
    • Node and Edge Patterns
    • Path Patterns
    • Quantified Paths
    • Shortest Paths
    • Graph Patterns
    • Overview
    • Typed Graph
    • Open Graph
    • Graph Sharding and Storage
    • Constraints
    • Unique Identifiers
    • INSERT
    • INSERT OVERWRITE
    • UPSERT
    • SET
    • REMOVE
    • DELETE
    • Query Composition
    • Result Table and Visualization
    • MATCH
    • OPTIONAL MATCH
    • FILTER
    • LET
    • FOR
    • ORDER BY
    • LIMIT
    • SKIP
    • CALL
    • RETURN
    • Composite Query
    • NEXT
    • All Functions
    • Scalar Functions
    • Path Functions
    • Aggregate Functions
    • Mathematical Functions
    • Trigonometric Functions
    • String Functions
    • List Functions
    • Datetime Functions
    • Spatial Functions
    • Table Functions
  • Operators
  • Predicates
  • Expressions
    • Index
    • Full-text Index
    • Vector Index
    • Managing HDC Graphs
    • HDC Graph Queries
  • Transaction
  • Trigger
    • Process
    • Job
    • Execution Plan
    • Variables
    • Values and Types
    • Comments
    • Reserved Words
    • Syntactic Notation
  • Access Control
  • GQL Conformance
  1. Docs
  2. /
  3. ISO GQL
  4. /
  5. GQL Execution

Job

Overview

Certain GQL operations, such as schema dropping, projection creation, and algorithm writeback, are designed to run as back-end jobs. The results of some jobs, such as files generated by algorithms, are stored in the graphs on which they are executed and can be retrieved later, unless cleared.

Showing Jobs

To retrieve all jobs in the current graph:

GQL
SHOW JOB

To retrieve the job with id 83 in the current graph:

GQL
SHOW JOB 83

It returns the following information for each job:

Field
Description
job_idJob ID. Some jobs have sub-jobs with ids <jobId>_1,<jobId>_2, and so on.
graph_nameThe graph on which the job executes.
typeJob type, such as CREATE_INDEX, CACHE, COMPACT etc.
queryQuery of the job.
statusJob status, which can be FINISHED, RUNNING, STOPPING, STOPPED or FAILED.
err_msgError message, if any, encountered during the job's execution.
resultResults generated by the job, such as output files or statistical summaries from an algorithm.
start_timeStart time of the job.
end_timeEnd time of the job.
progressProgress updates for the job, such as indications that the write operation has been started.

Stopping Jobs

To stop the running job with id 83 in the current graph:

GQL
STOP JOB 83
NOTE

Certain job types cannot be stopped once they are running. These include COMPACT, CREATE_INDEX, CREATE_FULLTEXT, CREATE_CONSTRAINT, MIGRATION, and CREATE_BACKUP.

Deleting Jobs

To delete all jobs in the current graph that are not running:

GQL
DELETE JOB *

To delete the job with ID 83 in the current graph:

GQL
DELETE JOB 83