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

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
createTime	string (date-time)	The time that the job execution was created.
currentAttemptStartTime	string (date-time)	Start time of the current attempt.
currentAttempts	integer	Number of times the job execution has been attempted.
endTime	string (date-time)	The time that the job execution completed.
jobExecutionId	string	The unique identifier of the job execution.
jobVersion	integer	The job version number.
lastMessage	string	The last status or error message.
lifecycle	string	The detailed state of the job execution. Known values are: "Created", "InProgress", "WaitingForChildJobExecutions", "WaitingForRetry", "Succeeded", "SucceededWithSkipped", "Failed", "TimedOut", "Canceled", and "Skipped". (Created, InProgress, WaitingForChildJobExecutions, WaitingForRetry, Succeeded, SucceededWithSkipped, Failed, TimedOut, Canceled, Skipped)
provisioningState	string	The ARM provisioning state of the job execution. Known values are: "Created", "InProgress", "Succeeded", "Failed", and "Canceled". (Created, InProgress, Succeeded, Failed, Canceled)
startTime	string (date-time)	The time that the job execution started.
stepId	integer	The job step id.
stepName	string	The job step name.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
target	object	The target that this execution is executed on.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

list_by_job_execution

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
createTime	string (date-time)	The time that the job execution was created.
currentAttemptStartTime	string (date-time)	Start time of the current attempt.
currentAttempts	integer	Number of times the job execution has been attempted.
endTime	string (date-time)	The time that the job execution completed.
jobExecutionId	string	The unique identifier of the job execution.
jobVersion	integer	The job version number.
lastMessage	string	The last status or error message.
lifecycle	string	The detailed state of the job execution. Known values are: "Created", "InProgress", "WaitingForChildJobExecutions", "WaitingForRetry", "Succeeded", "SucceededWithSkipped", "Failed", "TimedOut", "Canceled", and "Skipped". (Created, InProgress, WaitingForChildJobExecutions, WaitingForRetry, Succeeded, SucceededWithSkipped, Failed, TimedOut, Canceled, Skipped)
provisioningState	string	The ARM provisioning state of the job execution. Known values are: "Created", "InProgress", "Succeeded", "Failed", and "Canceled". (Created, InProgress, Succeeded, Failed, Canceled)
startTime	string (date-time)	The time that the job execution started.
stepId	integer	The job step id.
stepName	string	The job step name.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
target	object	The target that this execution is executed on.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resource_group_name, server_name, job_agent_name, job_name, job_execution_id, step_name, subscription_id		Gets a step execution of a job execution.
list_by_job_execution	select	resource_group_name, server_name, job_agent_name, job_name, job_execution_id, subscription_id	createTimeMin, createTimeMax, endTimeMin, endTimeMax, isActive, $skip, $top	Lists the step executions of a job execution.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
job_agent_name	string	The name of the job agent. Required.
job_execution_id	string	The unique id of the job execution. Required.
job_name	string	The name of the job to get. Required.
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
server_name	string	The name of the server. Required.
step_name	string	The name of the step. Required.
subscription_id	string
$skip	integer	The number of elements in the collection to skip. Default value is None.
$top	integer	The number of elements to return from the collection. Default value is None.
createTimeMax	string (date-time)	If specified, only job executions created before the specified time are included. Default value is None.
createTimeMin	string (date-time)	If specified, only job executions created at or after the specified time are included. Default value is None.
endTimeMax	string (date-time)	If specified, only job executions completed before the specified time are included. Default value is None.
endTimeMin	string (date-time)	If specified, only job executions completed at or after the specified time are included. Default value is None.
isActive	boolean	If specified, only active or only completed job executions are included. Default value is None.

SELECT examples

get

Gets a step execution of a job execution.

SELECT
id,
name,
createTime,
currentAttemptStartTime,
currentAttempts,
endTime,
jobExecutionId,
jobVersion,
lastMessage,
lifecycle,
provisioningState,
startTime,
stepId,
stepName,
systemData,
target,
type
FROM azure.sql.job_step_executions
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND server_name = '{{ server_name }}' -- required
AND job_agent_name = '{{ job_agent_name }}' -- required
AND job_name = '{{ job_name }}' -- required
AND job_execution_id = '{{ job_execution_id }}' -- required
AND step_name = '{{ step_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_job_execution

Lists the step executions of a job execution.

SELECT
id,
name,
createTime,
currentAttemptStartTime,
currentAttempts,
endTime,
jobExecutionId,
jobVersion,
lastMessage,
lifecycle,
provisioningState,
startTime,
stepId,
stepName,
systemData,
target,
type
FROM azure.sql.job_step_executions
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND server_name = '{{ server_name }}' -- required
AND job_agent_name = '{{ job_agent_name }}' -- required
AND job_name = '{{ job_name }}' -- required
AND job_execution_id = '{{ job_execution_id }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND createTimeMin = '{{ createTimeMin }}'
AND createTimeMax = '{{ createTimeMax }}'
AND endTimeMin = '{{ endTimeMin }}'
AND endTimeMax = '{{ endTimeMax }}'
AND isActive = '{{ isActive }}'
AND $skip = '{{ $skip }}'
AND $top = '{{ $top }}'
;