scheduled_actions

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

Overview

Name	scheduled_actions
Type	Resource
Id	azure.cost_management.scheduled_actions

Fields

vw_scheduled_actions

Name	Datatype	Description
name	text	field from the properties object
display_name	text	field from the properties object
e_tag	text	field from the properties object
file_destination	text	field from the properties object
kind	text	Kind of the scheduled action.
notification	text	field from the properties object
notification_email	text	field from the properties object
schedule	text	field from the properties object
scope	text	field from the properties object
status	text	field from the properties object
system_data	text	field from the properties object
view_id	text	field from the properties object

scheduled_actions

Name	Datatype	Description
eTag	string	Resource Etag. For update calls, eTag is optional and can be specified to achieve optimistic concurrency. Fetch the resource's eTag by doing a 'GET' call first and then including the latest eTag as part of the request body or 'If-Match' header while performing the update. For create calls, eTag is not required.
kind	string	Kind of the scheduled action.
properties	object	The properties of the scheduled action.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	name	Get the private scheduled action by name.
get_by_scope	SELECT	name, scope	Get the shared scheduled action from the given scope by name.
list	SELECT		List all private scheduled actions.
list_by_scope	SELECT	scope	List all shared scheduled actions within the given scope.
create_or_update	INSERT	name	Create or update a private scheduled action.
delete	DELETE	name	Delete a private scheduled action.
delete_by_scope	DELETE	name, scope	Delete a scheduled action within the given scope.
check_name_availability	EXEC		Checks availability and correctness of the name for a scheduled action.
check_name_availability_by_scope	EXEC	scope	Checks availability and correctness of the name for a scheduled action within the given scope.
run	EXEC	name	Processes a private scheduled action.
run_by_scope	EXEC	name, scope	Runs a shared scheduled action within the given scope.

SELECT examples

List all private scheduled actions.

vw_scheduled_actions

SELECT
name,
display_name,
e_tag,
file_destination,
kind,
notification,
notification_email,
schedule,
scope,
status,
system_data,
view_id
FROM azure.cost_management.vw_scheduled_actions
;

scheduled_actions

SELECT
eTag,
kind,
properties,
systemData
FROM azure.cost_management.scheduled_actions
;

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.cost_management.scheduled_actions (
name,
kind,
systemData,
properties
)
SELECT 
'{{ name }}',
'{{ kind }}',
'{{ systemData }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: eTag
      value: string
    - name: kind
      value: []
    - 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: displayName
          value: string
        - name: fileDestination
          value:
            - name: fileFormats
              value:
                - []
        - name: notification
          value:
            - name: to
              value:
                - string
            - name: language
              value: []
            - name: message
              value: string
            - name: regionalFormat
              value: []
            - name: subject
              value: string
        - name: notificationEmail
          value: []
        - name: schedule
          value:
            - name: frequency
              value: []
            - name: hourOfDay
              value: integer
            - name: daysOfWeek
              value:
                - []
            - name: weeksOfMonth
              value:
                - []
            - name: dayOfMonth
              value: integer
            - name: startDate
              value: string
            - name: endDate
              value: string
        - name: scope
          value: string
        - name: status
          value: []
        - name: viewId
          value: string

DELETE example

Deletes the specified scheduled_actions resource.

/*+ delete */
DELETE FROM azure.cost_management.scheduled_actions
WHERE name = '{{ name }}';