job_executions

Creates, updates, deletes, gets or lists a job_executions resource.

Overview

Name	job_executions
Type	Resource
Id	azure.sql.job_executions

Fields

vw_job_executions

Name	Datatype	Description
create_time	text	field from the properties object
current_attempt_start_time	text	field from the properties object
current_attempts	text	field from the properties object
end_time	text	field from the properties object
jobAgentName	text	field from the properties object
jobExecutionId	text	field from the properties object
jobName	text	field from the properties object
job_execution_id	text	field from the properties object
job_version	text	field from the properties object
last_message	text	field from the properties object
lifecycle	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
start_time	text	field from the properties object
step_id	text	field from the properties object
step_name	text	field from the properties object
subscriptionId	text	field from the properties object
target	text	field from the properties object

job_executions

Name	Datatype	Description
properties	object	Properties for an Azure SQL Database Elastic job execution.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	jobAgentName, jobExecutionId, jobName, resourceGroupName, serverName, subscriptionId	Gets a job execution.
list_by_agent	SELECT	jobAgentName, resourceGroupName, serverName, subscriptionId	Lists all executions in a job agent.
list_by_job	SELECT	jobAgentName, jobName, resourceGroupName, serverName, subscriptionId	Lists a job's executions.
create	INSERT	jobAgentName, jobName, resourceGroupName, serverName, subscriptionId	Starts an elastic job execution.
create_or_update	INSERT	jobAgentName, jobExecutionId, jobName, resourceGroupName, serverName, subscriptionId	Creates or updates a job execution.
cancel	EXEC	jobAgentName, jobExecutionId, jobName, resourceGroupName, serverName, subscriptionId	Requests cancellation of a job execution.

SELECT examples

Lists all executions in a job agent.

vw_job_executions

SELECT
create_time,
current_attempt_start_time,
current_attempts,
end_time,
jobAgentName,
jobExecutionId,
jobName,
job_execution_id,
job_version,
last_message,
lifecycle,
provisioning_state,
resourceGroupName,
serverName,
start_time,
step_id,
step_name,
subscriptionId,
target
FROM azure.sql.vw_job_executions
WHERE jobAgentName = '{{ jobAgentName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

job_executions

SELECT
properties
FROM azure.sql.job_executions
WHERE jobAgentName = '{{ jobAgentName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new job_executions resource.

All Properties

/*+ create */
INSERT INTO azure.sql.job_executions (
jobAgentName,
jobName,
resourceGroupName,
serverName,
subscriptionId
)
SELECT 
'{{ jobAgentName }}',
'{{ jobName }}',
'{{ resourceGroupName }}',
'{{ serverName }}',
'{{ subscriptionId }}'
;

Manifest

- name: your_resource_model_name
  props: []