Certain UQL 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 graphsets on which they are executed and can be retrieved later, unless cleared.
To retrieve all jobs in the current graphset:
UQLshow().job()
To retrieve the job with id 83 in the current graphset:
UQLshow().job(83)
It returns the following information for each job:
Field | Description |
|---|---|
Job ID | Job ID. Some jobs have sub-jobs with ids <jobId>_1,<jobId>_2, and so on. |
Graph Name | The graphset on which the job executes. |
Type | Job type, such as CREATE_INDEX, CACHE, COMPACT etc. |
Query | Query of the job. |
Start Time | Start time of the job. |
End Time | End time of the job. |
Result | Results generated by the job, such as output files or statistical summaries from an algorithm. |
Error Msg | Error message, if any, encountered during the job's execution. |
Status | Job status, which can be FINISHED, RUNNING, STOPPING, STOPPED or FAILED. |
Progress | Progress updates for the job, such as indications that the write operation has been started. |
To stop the running job with id 83 in the current graphset:
UQLstop().job(83)
NOTECertain job types cannot be stopped once they are running. These include
COMPACT,CREATE_INDEX,CREATE_FULLTEXT,CREATE_CONSTRAINT,MIGRATION, andCREATE_BACKUP.
To clear all jobs in the current graphset that are not running:
UQLclear().job("*")
To clear the job with ID 83 in the current graphset:
UQLclear().job(83)
