get_job()
relationalai.api
get_job(reasoner_type STRING, id STRING)A procedure that retrieves details for a specific job.
Requires the all_schema_ro application role.
Parameters
Section titled “Parameters”| Name | Type | Description |
|---|---|---|
reasoner_type | STRING | Reasoner type (for example, 'predictive'). |
id | STRING | Job ID. |
Returns
Section titled “Returns”A table with the following columns:
| Column | Type | Description |
|---|---|---|
ID | STRING | Job ID. |
REASONER_TYPE | STRING | Reasoner type. |
REASONER_NAME | STRING | Reasoner name. |
STATE | STRING | Job state. |
CREATED_BY | STRING | User who created the job. |
CREATED_ON | TIMESTAMP_LTZ | Job creation timestamp. |
FINISHED_AT | TIMESTAMP_LTZ | Job completion timestamp. |
DURATION | INT | Job duration in milliseconds. |
PAYLOAD | STRING | Job payload. |
TIMEOUT_MS | INT | Timeout in milliseconds. |
ABORT_REASON | STRING | Reason the job was aborted (if applicable). |
Example
Section titled “Example”Get the details for a job:
CALL relationalai.api.get_job('predictive', 'abc123');