- Categories:
GET_JOB_HISTORY¶
Returns the job history for Snowpark Container Services jobs that ran within the specified time range. The function returns both the running and deleted job.
- See also:
Syntax¶
SNOWFLAKE.SPCS.GET_JOB_HISTORY(
[ CREATED_TIME_START => <constant_expr> ],
[ CREATED_TIME_END => <constant_expr> ],
[ RESULT_LIMIT = <integer> ])
Arguments¶
CREATED_TIME_START => constant_exprStart time, in TIMESTAMP_LTZ format — for example, ‘2024-04-05 01:02:03’ — for the time range when jobs were created to retrieve the job history. For available functions to construct data, time, and timestamp data, see Date & time functions.
Default: 14 days from the current timestamp.
CREATED_TIME_END => constant_exprEnd time, in TIMESTAMP_LTZ format, for the time range to retrieve the job history.
Default: Current timestamp.
RESULT_LIMIT => integerMaximum number of rows to return.
If the number of matching rows exceeds the specified limit, only the jobs with the most recent timestamps are returned, up to the specified limit.
Range: 1 to 10000
Default: 100
Output¶
The function returns the following columns:
Column |
Data Type |
Description |
|---|---|---|
|
VARCHAR |
ID of the EXECUTE JOB SERVICE SQL statement. |
|
NUMBER |
Internal/system-generated identifier for the job. |
|
VARCHAR |
Name of the job. |
|
VARCHAR |
Name of the database in which the job is created. |
|
VARCHAR |
Name of the schema in which the job is created. |
|
TIMESTAMP_LTZ |
Time when the job was created. |
|
TIMESTAMP_LTZ |
Time when the job was completed. |
|
TIMESTAMP_LTZ |
Time when the job was deleted. |
|
VARCHAR |
Staus of the job. |
|
VARCHAR |
Additional information about the job status. |
|
OBJECT |
Key-value pairs that describe job instances and containers. |
|
VARCHAR |
Name of the compute pool where the job was run. |
|
VARCHAR |
Role that owns the job. |
|
VARCHAR |
Type of role that owns the job, either ROLE or DATABASE_ROLE. |
|
OBJECT |
Key-value pairs that describe the parameters that were specified when the job was created. |
|
OBJECT |
Key-value pairs that describe the managing object. NULL if the job isn’t managed by Snowflake. |
Access control requirements¶
The PUBLIC role has the privilege to use this function.
Everyone can call this function, but the output depends on the current role. The output only includes the jobs that are owned by the current role.
Examples¶
Returns the job history of all jobs created by the current role within the last 14 days (the default
CREATED_TIME_STARTvalue).SELECT * FROM TABLE(SNOWFLAKE.SPCS.GET_JOB_HISTORY(());
The following example output shows only one job:
+--------------------------------------+-----+-------------+---------------+-------------+-------------------------------+-------------------------------+--------------+--------+-----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------+-----------+-----------------+-----------------+-----------------+ | QUERY_ID | ID | NAME | DATABASE_NAME | SCHEMA_NAME | CREATED_TIME | COMPLETED_TIME | DELETED_TIME | STATUS | MESSAGE | INSTANCE_STATUSES | COMPUTE_POOL_NAME | OWNER | OWNER_ROLE_TYPE | PARAMETERS | MANAGING_OBJECT | |--------------------------------------+-----+-------------+---------------+-------------+-------------------------------+-------------------------------+--------------+--------+-----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------+-----------+-----------------+-----------------+-----------------| | 01bd46d2-0004-be62-0000-ff07016490a6 | 131 | MY_TEST_JOB | TUTORIAL_DB | DATA_SCHEMA | 2025-06-25 17:50:00.728 -0700 | 2025-06-25 17:50:10.515 -0700 | NULL | DONE | Job completed successfully. | { | TUTORIAL_COMPUTE_POOL | TEST_ROLE | ROLE | { | NULL | | | | | | | | | | | | "failedInstances": 0, | | | | "ASYNC": true | | | | | | | | | | | | | "instances": [ | | | | } | | | | | | | | | | | | | { | | | | | | | | | | | | | | | | | "containers": [ | | | | | | | | | | | | | | | | | { | | | | | | | | | | | | | | | | | "containerName": "main", | | | | | | | | | | | | | | | | | "image": "org-account.registry.snowflakecomputing.com/tutorial_db/data_schema/tutorial_repository/my_job_image:latest", | | | | | | | | | | | | | | | | | "imageSha256": "sha256:ff07f19f233cfe76a889e39d9d7098d528312acc789f1c0cf929556a56c61a9a", | | | | | | | | | | | | | | | | | "lastExitCode": 0, | | | | | | | | | | | | | | | | | "message": "Completed successfully", | | | | | | | | | | | | | | | | | "restartCount": 0, | | | | | | | | | | | | | | | | | "startTime": "", | | | | | | | | | | | | | | | | | "status": "DONE" | | | | | | | | | | | | | | | | | } | | | | | | | | | | | | | | | | | ], | | | | | | | | | | | | | | | | | "instanceId": "0" | | | | | | | | | | | | | | | | | } | | | | | | | | | | | | | | | | | ], | | | | | | | | | | | | | | | | | "pendingInstances": 0, | | | | | | | | | | | | | | | | | "runningInstances": 0, | | | | | | | | | | | | | | | | | "succeededInstances": 1, | | | | | | | | | | | | | | | | | "totalInstances": 1 | | | | | | | | | | | | | | | | | } | | | | | | +--------------------------------------+-----+-------------+---------------+-------------+-------------------------------+-------------------------------+--------------+--------+-----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------+-----------+-----------------+-----------------+-----------------+
Returns the job history of up to 10 jobs that are owned by the current role that ran within the last three days.
SELECT * FROM TABLE(snowflake.spcs.get_job_history( result_limit => 10, created_time_start => dateadd('day', -3, current_timestamp()) ));
Retrieves up to 10 jobs that ran between three days ago and one day ago, not including today.
SELECT * FROM TABLE(SNOWFLAKE.SPCS.GET_JOB_HISTORY( RESULT_LIMIT => 10, CREATED_TIME_START => DATEADD('day', -3, CURRENT_TIMESTAMP()), CREATED_TIME_END => DATEADD('day', -1, CURRENT_TIMESTAMP())));