job_versions
Creates, updates, deletes, gets or lists a job_versions resource.
Overview
| Name | job_versions |
| Type | Resource |
| Id | azure.sql.job_versions |
Fields
SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.
Methods
| Name | Accessible by | Required Params | Description |
|---|---|---|---|
get | SELECT | jobAgentName, jobName, jobVersion, resourceGroupName, serverName, subscriptionId | Gets a job version. |
list_by_job | SELECT | jobAgentName, jobName, resourceGroupName, serverName, subscriptionId | Gets all versions of a job. |
SELECT examples
Gets all versions of a job.
SELECT
FROM azure.sql.job_versions
WHERE jobAgentName = '{{ jobAgentName }}'
AND jobName = '{{ jobName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';