sql_jobs_controllers

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

Overview

Name	sql_jobs_controllers
Type	Resource
Id	azure.migrate.sql_jobs_controllers

Fields

vw_sql_jobs_controllers

Name	Datatype	Description
activity_id	text	field from the properties object
client_request_id	text	field from the properties object
display_name	text	field from the properties object
end_time	text	field from the properties object
errors	text	field from the properties object
jobName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
siteName	text	field from the properties object
sqlSiteName	text	field from the properties object
start_time	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object

sql_jobs_controllers

Name	Datatype	Description
properties	object	Job REST Resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	jobName, resourceGroupName, siteName, sqlSiteName, subscriptionId	Get a SqlJob
list_by_sql_site	SELECT	resourceGroupName, siteName, sqlSiteName, subscriptionId	List SqlJob resources by SqlSite

SELECT examples

List SqlJob resources by SqlSite

vw_sql_jobs_controllers

SELECT
activity_id,
client_request_id,
display_name,
end_time,
errors,
jobName,
provisioning_state,
resourceGroupName,
siteName,
sqlSiteName,
start_time,
status,
subscriptionId
FROM azure.migrate.vw_sql_jobs_controllers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND sqlSiteName = '{{ sqlSiteName }}'
AND subscriptionId = '{{ subscriptionId }}';

sql_jobs_controllers

SELECT
properties
FROM azure.migrate.sql_jobs_controllers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND sqlSiteName = '{{ sqlSiteName }}'
AND subscriptionId = '{{ subscriptionId }}';