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;