recommended_scheduled_actions

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

Overview

Name	recommended_scheduled_actions
Type	Resource
Id	oci.database.recommended_scheduled_actions

Fields

The following fields are returned by SELECT queries:

list

The Scheduling Actions configuration.

Name	Datatype	Description
actionMembers	array	The list of action members in a scheduled action.
actionOrder	integer	The order of the scheduled action.
actionParams	object	Map<ParamName, ParamValue> where a key value pair describes the specific action parameter. Example: &#123;"count": "3"&#125;
actionType	string	The type of the scheduled action being performed (DB_SERVER_FULL_SOFTWARE_UPDATE, STORAGE_SERVER_FULL_SOFTWARE_UPDATE, NETWORK_SWITCH_FULL_SOFTWARE_UPDATE, DB_SERVER_ONLINE_SOFTWARE_UPDATE) (default: DB_SERVER_FULL_SOFTWARE_UPDATE)
displayName	string	Description of the scheduled action being performed, i.e. apply full update to DB Servers 1,2,3,4.
estimatedTimeInMins	integer	The estimated patching time in minutes for the entire scheduled action.
schedulingWindowId	string	The id of the scheduling window this scheduled action belongs to.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	schedulingPolicyId, schedulingPolicyTargetResourceId, planIntent, region	limit, page, opc-request-id	Returns a recommended Scheduled Actions configuration for a given resource, plan intent and scheduling policy.<br />

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
planIntent	string	The scheduling plan intent the scheduled actions will be for.
region	string	OCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION)
schedulingPolicyId	string	The Scheduling Policy [OCID](/Content/General/Concepts/identifiers.htm).
schedulingPolicyTargetResourceId	string	The target resource [OCID](/Content/General/Concepts/identifiers.htm) the scheduled actions will be for.
limit	integer	The maximum number of items to return per page.
opc-request-id	string	Unique identifier for the request.
page	string	The pagination token to continue listing from.

SELECT examples

list

Returns a recommended Scheduled Actions configuration for a given resource, plan intent and scheduling policy.<br />

SELECT
actionMembers,
actionOrder,
actionParams,
actionType,
displayName,
estimatedTimeInMins,
schedulingWindowId
FROM oci.database.recommended_scheduled_actions
WHERE schedulingPolicyId = '{{ schedulingPolicyId }}' -- required
AND schedulingPolicyTargetResourceId = '{{ schedulingPolicyTargetResourceId }}' -- required
AND planIntent = '{{ planIntent }}' -- required
AND region = '{{ region }}' -- required
AND limit = '{{ limit }}'
AND page = '{{ page }}'
AND opc-request-id = '{{ opc-request-id }}'
;