job_step_executions

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

Overview

Name	job_step_executions
Type	Resource
Id	azure.sql.job_step_executions

Fields

vw_job_step_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
stepName	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_step_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, stepName, subscriptionId	Gets a step execution of a job execution.
list_by_job_execution	SELECT	jobAgentName, jobExecutionId, jobName, resourceGroupName, serverName, subscriptionId	Lists the step executions of a job execution.

SELECT examples

Lists the step executions of a job execution.

vw_job_step_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,
stepName,
step_id,
step_name,
subscriptionId,
target
FROM azure.sql.vw_job_step_executions
WHERE jobAgentName = '{{ jobAgentName }}'
AND jobExecutionId = '{{ jobExecutionId }}'
AND jobName = '{{ jobName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

job_step_executions

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