Skip to main content

scheduled_actions

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

Overview

Namescheduled_actions
TypeResource
Idazure.compute_schedule.scheduled_actions

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
actionTypestringThe action the scheduled action should perform in the resources. Required. Known values are: "Start", "Deallocate", and "Hibernate". (Start, Deallocate, Hibernate)
disabledbooleanTell if the scheduled action is disabled or not.
endTimestring (date-time)The time when the scheduled action is supposed to stop scheduling.
locationstringThe geo-location where the resource lives. Required.
notificationSettingsarrayThe notification settings for the scheduled action. Required.
provisioningStatestringThe status of the last provisioning operation performed on the resource. Known values are: "Succeeded", "Failed", "Canceled", and "Deleting". (Succeeded, Failed, Canceled, Deleting)
resourceTypestringThe type of resource the scheduled action is targeting. Required. Known values are: "VirtualMachine" and "VirtualMachineScaleSet". (VirtualMachine, VirtualMachineScaleSet)
scheduleobjectThe schedule the scheduled action is supposed to follow. Required.
startTimestring (date-time)The time which the scheduled action is supposed to start running. Required.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, scheduled_action_name, subscription_idGet a ScheduledAction.
list_by_resource_groupselectresource_group_name, subscription_idList ScheduledAction resources by resource group.
list_by_subscriptionselectsubscription_idList ScheduledAction resources by subscription ID.
create_or_updateinsertresource_group_name, scheduled_action_name, subscription_id, locationCreate a ScheduledAction.
updateupdateresource_group_name, scheduled_action_name, subscription_idUpdate a ScheduledAction.
create_or_updatereplaceresource_group_name, scheduled_action_name, subscription_id, locationCreate a ScheduledAction.
deletedeleteresource_group_name, scheduled_action_name, subscription_idDelete a ScheduledAction.
list_resourcesexecresource_group_name, scheduled_action_name, subscription_idList resources attached to Scheduled Actions.
virtual_machines_submit_deallocateexeclocationparameter, subscription_id, schedule, executionParameters, resources, correlationidVirtualMachinesSubmitDeallocate: Schedule deallocate operation for a batch of virtual machines at datetime in future.
virtual_machines_submit_hibernateexeclocationparameter, subscription_id, schedule, executionParameters, resources, correlationidVirtualMachinesSubmitHibernate: Schedule hibernate operation for a batch of virtual machines at datetime in future.
virtual_machines_submit_startexeclocationparameter, subscription_id, schedule, executionParameters, resources, correlationidVirtualMachinesSubmitStart: Schedule start operation for a batch of virtual machines at datetime in future.
virtual_machines_execute_deallocateexeclocationparameter, subscription_id, executionParameters, resources, correlationidVirtualMachinesExecuteDeallocate: Execute deallocate operation for a batch of virtual machines, this operation is triggered as soon as Computeschedule receives it.
virtual_machines_execute_hibernateexeclocationparameter, subscription_id, executionParameters, resources, correlationidVirtualMachinesExecuteHibernate: Execute hibernate operation for a batch of virtual machines, this operation is triggered as soon as Computeschedule receives it.
virtual_machines_execute_startexeclocationparameter, subscription_id, executionParameters, resources, correlationidVirtualMachinesExecuteStart: Execute start operation for a batch of virtual machines, this operation is triggered as soon as Computeschedule receives it.
virtual_machines_execute_createexeclocationparameter, subscription_id, resourceConfigParameters, executionParametersVirtualMachinesExecuteCreate: Execute create operation for a batch of virtual machines, this operation is triggered as soon as Computeschedule receives it.
virtual_machines_execute_deleteexeclocationparameter, subscription_id, executionParameters, resourcesVirtualMachinesExecuteDelete: Execute delete operation for a batch of virtual machines, this operation is triggered as soon as Computeschedule receives it.
virtual_machines_get_operation_statusexeclocationparameter, subscription_id, operationIds, correlationidVirtualMachinesGetOperationStatus: Polling endpoint to read status of operations performed on virtual machines.
virtual_machines_cancel_operationsexeclocationparameter, subscription_id, operationIds, correlationidVirtualMachinesCancelOperations: Cancel a previously submitted (start/deallocate/hibernate) request.
virtual_machines_get_operation_errorsexeclocationparameter, subscription_id, operationIdsVirtualMachinesGetOperationErrors: Get error details on operation errors (like transient errors encountered, additional logs) if they exist.
attach_resourcesexecresource_group_name, scheduled_action_name, subscription_id, resourcesA synchronous resource action.
detach_resourcesexecresource_group_name, scheduled_action_name, subscription_id, resourcesA synchronous resource action.
patch_resourcesexecresource_group_name, scheduled_action_name, subscription_id, resourcesA synchronous resource action.
disableexecresource_group_name, scheduled_action_name, subscription_idA synchronous resource action.
enableexecresource_group_name, scheduled_action_name, subscription_idA synchronous resource action.
cancel_next_occurrenceexecresource_group_name, scheduled_action_name, subscription_id, resourceIdsA synchronous resource action.
trigger_manual_occurrenceexecresource_group_name, scheduled_action_name, subscription_idA synchronous resource action.

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.

NameDatatypeDescription
locationparameterstringThe location name. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
scheduled_action_namestringThe name of the ScheduledAction. Required.
subscription_idstring

SELECT examples

Get a ScheduledAction.

SELECT
id,
name,
actionType,
disabled,
endTime,
location,
notificationSettings,
provisioningState,
resourceType,
schedule,
startTime,
systemData,
tags,
type
FROM azure.compute_schedule.scheduled_actions
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND scheduled_action_name = '{{ scheduled_action_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create a ScheduledAction.

INSERT INTO azure.compute_schedule.scheduled_actions (
tags,
location,
properties,
resource_group_name,
scheduled_action_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ resource_group_name }}',
'{{ scheduled_action_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type
;

UPDATE examples

Update a ScheduledAction.

UPDATE azure.compute_schedule.scheduled_actions
SET
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND scheduled_action_name = '{{ scheduled_action_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

REPLACE examples

Create a ScheduledAction.

REPLACE azure.compute_schedule.scheduled_actions
SET
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND scheduled_action_name = '{{ scheduled_action_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

DELETE examples

Delete a ScheduledAction.

DELETE FROM azure.compute_schedule.scheduled_actions
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND scheduled_action_name = '{{ scheduled_action_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

List resources attached to Scheduled Actions.

EXEC azure.compute_schedule.scheduled_actions.list_resources 
@resource_group_name='{{ resource_group_name }}' --required,
@scheduled_action_name='{{ scheduled_action_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;