Functions
job_status
Get the status of an Agent Job.
Inputs
job_id
(String): The ID of the
Agent Job to get the status of.
This is usually the output of the run_agent
function.
Output
The status of the Agent Job. The status can be one of the following:
0: PENDING
1: STARTED
2: RETRY
3: SUCCESS
4: FAILURE
5: CANCELLED
Example Usage
SELECT job_status('123e4567-e89b-12d3-a456-426614174000');
SELECT job_status(run_agent_result_column) FROM data_table;