start_stop_managed_instance_schedules

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

Overview

Name	start_stop_managed_instance_schedules
Type	Resource
Id	azure.sql.start_stop_managed_instance_schedules

Fields

vw_start_stop_managed_instance_schedules

Name	Datatype	Description
description	text	field from the properties object
managedInstanceName	text	field from the properties object
next_execution_time	text	field from the properties object
next_run_action	text	field from the properties object
resourceGroupName	text	field from the properties object
schedule_list	text	field from the properties object
startStopScheduleName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
time_zone_id	text	field from the properties object

start_stop_managed_instance_schedules

Name	Datatype	Description
properties	object	Properties of managed instance's Start/Stop schedule.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	managedInstanceName, resourceGroupName, startStopScheduleName, subscriptionId	Gets the managed instance's Start/Stop schedule.
create_or_update	INSERT	managedInstanceName, resourceGroupName, startStopScheduleName, subscriptionId	Creates or updates the managed instance's Start/Stop schedule.
delete	DELETE	managedInstanceName, resourceGroupName, startStopScheduleName, subscriptionId	Deletes the managed instance's Start/Stop schedule.

SELECT examples

Gets the managed instance's Start/Stop schedule.

vw_start_stop_managed_instance_schedules

SELECT
description,
managedInstanceName,
next_execution_time,
next_run_action,
resourceGroupName,
schedule_list,
startStopScheduleName,
subscriptionId,
system_data,
time_zone_id
FROM azure.sql.vw_start_stop_managed_instance_schedules
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND startStopScheduleName = '{{ startStopScheduleName }}'
AND subscriptionId = '{{ subscriptionId }}';

start_stop_managed_instance_schedules

SELECT
properties,
systemData
FROM azure.sql.start_stop_managed_instance_schedules
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND startStopScheduleName = '{{ startStopScheduleName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.start_stop_managed_instance_schedules (
managedInstanceName,
resourceGroupName,
startStopScheduleName,
subscriptionId,
properties
)
SELECT 
'{{ managedInstanceName }}',
'{{ resourceGroupName }}',
'{{ startStopScheduleName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: properties
      value:
        - name: description
          value: string
        - name: timeZoneId
          value: string
        - name: scheduleList
          value:
            - - name: startDay
                value: string
              - name: startTime
                value: string
              - name: stopDay
                value: string
              - name: stopTime
                value: string
        - name: nextRunAction
          value: string
        - name: nextExecutionTime
          value: string

DELETE example

Deletes the specified start_stop_managed_instance_schedules resource.

/*+ delete */
DELETE FROM azure.sql.start_stop_managed_instance_schedules
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND startStopScheduleName = '{{ startStopScheduleName }}'
AND subscriptionId = '{{ subscriptionId }}';