Get the status of an Agent Job.
job_id (String): The ID of the Agent Job to get the status of. This is usually the output of the run_agent function.
job_id
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
SELECT job_status('123e4567-e89b-12d3-a456-426614174000');
SELECT job_status(run_agent_result_column) FROM data_table;