job_target_executions

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

Overview

Name	job_target_executions
Type	Resource
Id	azure.sql.job_target_executions

Fields

vw_job_target_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
targetId	text	field from the properties object

job_target_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, targetId	Gets a target execution.
list_by_job_execution	SELECT	jobAgentName, jobExecutionId, jobName, resourceGroupName, serverName, subscriptionId	Lists target executions for all steps of a job execution.
list_by_step	SELECT	jobAgentName, jobExecutionId, jobName, resourceGroupName, serverName, stepName, subscriptionId	Lists the target executions of a job step execution.

SELECT examples

Lists target executions for all steps of a job execution.

vw_job_target_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,
targetId
FROM azure.sql.vw_job_target_executions
WHERE jobAgentName = '{{ jobAgentName }}'
AND jobExecutionId = '{{ jobExecutionId }}'
AND jobName = '{{ jobName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

job_target_executions

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