Oracle Cloud Infrastructure v2.32.0, Apr 24 25

Oracle Cloud Infrastructure v2.32.0 published on Thursday, Apr 24, 2025 by Pulumi

oci.Database.getExecutionWindows

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.32.0 published on Thursday, Apr 24, 2025 by Pulumi

Example Usage

TypeScript
Python
Go
C#
Java
YAML

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testExecutionWindows = oci.Database.getExecutionWindows({
    compartmentId: compartmentId,
    displayName: executionWindowDisplayName,
    executionResourceId: testResource.id,
    state: executionWindowState,
});

import pulumi
import pulumi_oci as oci

test_execution_windows = oci.Database.get_execution_windows(compartment_id=compartment_id,
    display_name=execution_window_display_name,
    execution_resource_id=test_resource["id"],
    state=execution_window_state)

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/database"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := database.GetExecutionWindows(ctx, &database.GetExecutionWindowsArgs{
			CompartmentId:       compartmentId,
			DisplayName:         pulumi.StringRef(executionWindowDisplayName),
			ExecutionResourceId: pulumi.StringRef(testResource.Id),
			State:               pulumi.StringRef(executionWindowState),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testExecutionWindows = Oci.Database.GetExecutionWindows.Invoke(new()
    {
        CompartmentId = compartmentId,
        DisplayName = executionWindowDisplayName,
        ExecutionResourceId = testResource.Id,
        State = executionWindowState,
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Database.DatabaseFunctions;
import com.pulumi.oci.Database.inputs.GetExecutionWindowsArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var testExecutionWindows = DatabaseFunctions.getExecutionWindows(GetExecutionWindowsArgs.builder()
            .compartmentId(compartmentId)
            .displayName(executionWindowDisplayName)
            .executionResourceId(testResource.id())
            .state(executionWindowState)
            .build());

    }
}

variables:
  testExecutionWindows:
    fn::invoke:
      function: oci:Database:getExecutionWindows
      arguments:
        compartmentId: ${compartmentId}
        displayName: ${executionWindowDisplayName}
        executionResourceId: ${testResource.id}
        state: ${executionWindowState}

Using getExecutionWindows

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

TypeScript
Python
Go
C#
Java
YAML

function getExecutionWindows(args: GetExecutionWindowsArgs, opts?: InvokeOptions): Promise<GetExecutionWindowsResult>
function getExecutionWindowsOutput(args: GetExecutionWindowsOutputArgs, opts?: InvokeOptions): Output<GetExecutionWindowsResult>

def get_execution_windows(compartment_id: Optional[str] = None,
                          display_name: Optional[str] = None,
                          execution_resource_id: Optional[str] = None,
                          filters: Optional[Sequence[_database.GetExecutionWindowsFilter]] = None,
                          state: Optional[str] = None,
                          opts: Optional[InvokeOptions] = None) -> GetExecutionWindowsResult
def get_execution_windows_output(compartment_id: Optional[pulumi.Input[str]] = None,
                          display_name: Optional[pulumi.Input[str]] = None,
                          execution_resource_id: Optional[pulumi.Input[str]] = None,
                          filters: Optional[pulumi.Input[Sequence[pulumi.Input[_database.GetExecutionWindowsFilterArgs]]]] = None,
                          state: Optional[pulumi.Input[str]] = None,
                          opts: Optional[InvokeOptions] = None) -> Output[GetExecutionWindowsResult]

func GetExecutionWindows(ctx *Context, args *GetExecutionWindowsArgs, opts ...InvokeOption) (*GetExecutionWindowsResult, error)
func GetExecutionWindowsOutput(ctx *Context, args *GetExecutionWindowsOutputArgs, opts ...InvokeOption) GetExecutionWindowsResultOutput

> Note: This function is named GetExecutionWindows in the Go SDK.

public static class GetExecutionWindows 
{
    public static Task<GetExecutionWindowsResult> InvokeAsync(GetExecutionWindowsArgs args, InvokeOptions? opts = null)
    public static Output<GetExecutionWindowsResult> Invoke(GetExecutionWindowsInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetExecutionWindowsResult> getExecutionWindows(GetExecutionWindowsArgs args, InvokeOptions options)
public static Output<GetExecutionWindowsResult> getExecutionWindows(GetExecutionWindowsArgs args, InvokeOptions options)

fn::invoke:
  function: oci:Database/getExecutionWindows:getExecutionWindows
  arguments:
    # arguments dictionary

The following arguments are supported:

CompartmentId string: The compartment OCID.
DisplayName string: A filter to return only resources that match the entire display name given. The match is not case sensitive.
ExecutionResourceId string: A filter to return only resources that match the given resource id exactly.
Filters List<GetExecutionWindowsFilter>
State string: A filter to return only resources that match the given lifecycle state exactly.

CompartmentId string: The compartment OCID.
DisplayName string: A filter to return only resources that match the entire display name given. The match is not case sensitive.
ExecutionResourceId string: A filter to return only resources that match the given resource id exactly.
Filters []GetExecutionWindowsFilter
State string: A filter to return only resources that match the given lifecycle state exactly.

compartmentId String: The compartment OCID.
displayName String: A filter to return only resources that match the entire display name given. The match is not case sensitive.
executionResourceId String: A filter to return only resources that match the given resource id exactly.
filters List<GetExecutionWindowsFilter>
state String: A filter to return only resources that match the given lifecycle state exactly.

compartmentId string: The compartment OCID.
displayName string: A filter to return only resources that match the entire display name given. The match is not case sensitive.
executionResourceId string: A filter to return only resources that match the given resource id exactly.
filters GetExecutionWindowsFilter[]
state string: A filter to return only resources that match the given lifecycle state exactly.

compartment_id str: The compartment OCID.
display_name str: A filter to return only resources that match the entire display name given. The match is not case sensitive.
execution_resource_id str: A filter to return only resources that match the given resource id exactly.
filters Sequence[database.GetExecutionWindowsFilter]
state str: A filter to return only resources that match the given lifecycle state exactly.

compartmentId String: The compartment OCID.
displayName String: A filter to return only resources that match the entire display name given. The match is not case sensitive.
executionResourceId String: A filter to return only resources that match the given resource id exactly.
filters List<Property Map>
state String: A filter to return only resources that match the given lifecycle state exactly.

getExecutionWindows Result

The following output properties are available:

CompartmentId string: The OCID of the compartment.
ExecutionWindows List<GetExecutionWindowsExecutionWindow>: The list of execution_windows.
Id string: The provider-assigned unique ID for this managed resource.
DisplayName string: The user-friendly name for the execution window. The name does not need to be unique.
ExecutionResourceId string: The OCID of the execution resource the execution window belongs to.
Filters List<GetExecutionWindowsFilter>
State string: The current state of the Schedule Policy. Valid states are CREATED, SCHEDULED, IN_PROGRESS, FAILED, CANCELED, UPDATING, DELETED, SUCCEEDED and PARTIAL_SUCCESS.

CompartmentId string: The OCID of the compartment.
ExecutionWindows []GetExecutionWindowsExecutionWindow: The list of execution_windows.
Id string: The provider-assigned unique ID for this managed resource.
DisplayName string: The user-friendly name for the execution window. The name does not need to be unique.
ExecutionResourceId string: The OCID of the execution resource the execution window belongs to.
Filters []GetExecutionWindowsFilter
State string: The current state of the Schedule Policy. Valid states are CREATED, SCHEDULED, IN_PROGRESS, FAILED, CANCELED, UPDATING, DELETED, SUCCEEDED and PARTIAL_SUCCESS.

compartmentId String: The OCID of the compartment.
executionWindows List<GetExecutionWindowsExecutionWindow>: The list of execution_windows.
id String: The provider-assigned unique ID for this managed resource.
displayName String: The user-friendly name for the execution window. The name does not need to be unique.
executionResourceId String: The OCID of the execution resource the execution window belongs to.
filters List<GetExecutionWindowsFilter>
state String: The current state of the Schedule Policy. Valid states are CREATED, SCHEDULED, IN_PROGRESS, FAILED, CANCELED, UPDATING, DELETED, SUCCEEDED and PARTIAL_SUCCESS.

compartmentId string: The OCID of the compartment.
executionWindows GetExecutionWindowsExecutionWindow[]: The list of execution_windows.
id string: The provider-assigned unique ID for this managed resource.
displayName string: The user-friendly name for the execution window. The name does not need to be unique.
executionResourceId string: The OCID of the execution resource the execution window belongs to.
filters GetExecutionWindowsFilter[]
state string: The current state of the Schedule Policy. Valid states are CREATED, SCHEDULED, IN_PROGRESS, FAILED, CANCELED, UPDATING, DELETED, SUCCEEDED and PARTIAL_SUCCESS.

compartment_id str: The OCID of the compartment.
execution_windows Sequence[database.GetExecutionWindowsExecutionWindow]: The list of execution_windows.
id str: The provider-assigned unique ID for this managed resource.
display_name str: The user-friendly name for the execution window. The name does not need to be unique.
execution_resource_id str: The OCID of the execution resource the execution window belongs to.
filters Sequence[database.GetExecutionWindowsFilter]
state str: The current state of the Schedule Policy. Valid states are CREATED, SCHEDULED, IN_PROGRESS, FAILED, CANCELED, UPDATING, DELETED, SUCCEEDED and PARTIAL_SUCCESS.

compartmentId String: The OCID of the compartment.
executionWindows List<Property Map>: The list of execution_windows.
id String: The provider-assigned unique ID for this managed resource.
displayName String: The user-friendly name for the execution window. The name does not need to be unique.
executionResourceId String: The OCID of the execution resource the execution window belongs to.
filters List<Property Map>
state String: The current state of the Schedule Policy. Valid states are CREATED, SCHEDULED, IN_PROGRESS, FAILED, CANCELED, UPDATING, DELETED, SUCCEEDED and PARTIAL_SUCCESS.

Supporting Types

GetExecutionWindowsExecutionWindow

CompartmentId string: The compartment OCID.
DefinedTags Dictionary<string, string>: Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
Description string: Description of the execution window.
DisplayName string: A filter to return only resources that match the entire display name given. The match is not case sensitive.
EstimatedTimeInMins int: The estimated time of the execution window in minutes.
ExecutionResourceId string: A filter to return only resources that match the given resource id exactly.
FreeformTags Dictionary<string, string>: Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
Id string: The OCID of the execution window.
IsEnforcedDuration bool: Indicates if duration the user plans to allocate for scheduling window is strictly enforced. The default value is FALSE.
LifecycleDetails string: Additional information about the current lifecycle state.
LifecycleSubstate string: The current sub-state of the execution window. Valid states are DURATION_EXCEEDED, MAINTENANCE_IN_PROGRESS and WAITING.
State string: A filter to return only resources that match the given lifecycle state exactly.
TimeCreated string: The date and time the execution window was created.
TimeEnded string: The date and time that the execution window ended.
TimeScheduled string: The scheduled start date and time of the execution window.
TimeStarted string: The date and time that the execution window was started.
TimeUpdated string: The last date and time that the execution window was updated.
TotalTimeTakenInMins int: The total time taken by corresponding resource activity in minutes.
WindowDurationInMins int: Duration window allows user to set a duration they plan to allocate for Scheduling window. The duration is in minutes.
WindowType string: The execution window is of PLANNED or UNPLANNED type.

CompartmentId string: The compartment OCID.
DefinedTags map[string]string: Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
Description string: Description of the execution window.
DisplayName string: A filter to return only resources that match the entire display name given. The match is not case sensitive.
EstimatedTimeInMins int: The estimated time of the execution window in minutes.
ExecutionResourceId string: A filter to return only resources that match the given resource id exactly.
FreeformTags map[string]string: Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
Id string: The OCID of the execution window.
IsEnforcedDuration bool: Indicates if duration the user plans to allocate for scheduling window is strictly enforced. The default value is FALSE.
LifecycleDetails string: Additional information about the current lifecycle state.
LifecycleSubstate string: The current sub-state of the execution window. Valid states are DURATION_EXCEEDED, MAINTENANCE_IN_PROGRESS and WAITING.
State string: A filter to return only resources that match the given lifecycle state exactly.
TimeCreated string: The date and time the execution window was created.
TimeEnded string: The date and time that the execution window ended.
TimeScheduled string: The scheduled start date and time of the execution window.
TimeStarted string: The date and time that the execution window was started.
TimeUpdated string: The last date and time that the execution window was updated.
TotalTimeTakenInMins int: The total time taken by corresponding resource activity in minutes.
WindowDurationInMins int: Duration window allows user to set a duration they plan to allocate for Scheduling window. The duration is in minutes.
WindowType string: The execution window is of PLANNED or UNPLANNED type.

compartmentId String: The compartment OCID.
definedTags Map<String,String>: Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
description String: Description of the execution window.
displayName String: A filter to return only resources that match the entire display name given. The match is not case sensitive.
estimatedTimeInMins Integer: The estimated time of the execution window in minutes.
executionResourceId String: A filter to return only resources that match the given resource id exactly.
freeformTags Map<String,String>: Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
id String: The OCID of the execution window.
isEnforcedDuration Boolean: Indicates if duration the user plans to allocate for scheduling window is strictly enforced. The default value is FALSE.
lifecycleDetails String: Additional information about the current lifecycle state.
lifecycleSubstate String: The current sub-state of the execution window. Valid states are DURATION_EXCEEDED, MAINTENANCE_IN_PROGRESS and WAITING.
state String: A filter to return only resources that match the given lifecycle state exactly.
timeCreated String: The date and time the execution window was created.
timeEnded String: The date and time that the execution window ended.
timeScheduled String: The scheduled start date and time of the execution window.
timeStarted String: The date and time that the execution window was started.
timeUpdated String: The last date and time that the execution window was updated.
totalTimeTakenInMins Integer: The total time taken by corresponding resource activity in minutes.
windowDurationInMins Integer: Duration window allows user to set a duration they plan to allocate for Scheduling window. The duration is in minutes.
windowType String: The execution window is of PLANNED or UNPLANNED type.

compartmentId string: The compartment OCID.
definedTags {[key: string]: string}: Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
description string: Description of the execution window.
displayName string: A filter to return only resources that match the entire display name given. The match is not case sensitive.
estimatedTimeInMins number: The estimated time of the execution window in minutes.
executionResourceId string: A filter to return only resources that match the given resource id exactly.
freeformTags {[key: string]: string}: Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
id string: The OCID of the execution window.
isEnforcedDuration boolean: Indicates if duration the user plans to allocate for scheduling window is strictly enforced. The default value is FALSE.
lifecycleDetails string: Additional information about the current lifecycle state.
lifecycleSubstate string: The current sub-state of the execution window. Valid states are DURATION_EXCEEDED, MAINTENANCE_IN_PROGRESS and WAITING.
state string: A filter to return only resources that match the given lifecycle state exactly.
timeCreated string: The date and time the execution window was created.
timeEnded string: The date and time that the execution window ended.
timeScheduled string: The scheduled start date and time of the execution window.
timeStarted string: The date and time that the execution window was started.
timeUpdated string: The last date and time that the execution window was updated.
totalTimeTakenInMins number: The total time taken by corresponding resource activity in minutes.
windowDurationInMins number: Duration window allows user to set a duration they plan to allocate for Scheduling window. The duration is in minutes.
windowType string: The execution window is of PLANNED or UNPLANNED type.

compartment_id str: The compartment OCID.
defined_tags Mapping[str, str]: Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
description str: Description of the execution window.
display_name str: A filter to return only resources that match the entire display name given. The match is not case sensitive.
estimated_time_in_mins int: The estimated time of the execution window in minutes.
execution_resource_id str: A filter to return only resources that match the given resource id exactly.
freeform_tags Mapping[str, str]: Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
id str: The OCID of the execution window.
is_enforced_duration bool: Indicates if duration the user plans to allocate for scheduling window is strictly enforced. The default value is FALSE.
lifecycle_details str: Additional information about the current lifecycle state.
lifecycle_substate str: The current sub-state of the execution window. Valid states are DURATION_EXCEEDED, MAINTENANCE_IN_PROGRESS and WAITING.
state str: A filter to return only resources that match the given lifecycle state exactly.
time_created str: The date and time the execution window was created.
time_ended str: The date and time that the execution window ended.
time_scheduled str: The scheduled start date and time of the execution window.
time_started str: The date and time that the execution window was started.
time_updated str: The last date and time that the execution window was updated.
total_time_taken_in_mins int: The total time taken by corresponding resource activity in minutes.
window_duration_in_mins int: Duration window allows user to set a duration they plan to allocate for Scheduling window. The duration is in minutes.
window_type str: The execution window is of PLANNED or UNPLANNED type.

compartmentId String: The compartment OCID.
definedTags Map<String>: Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
description String: Description of the execution window.
displayName String: A filter to return only resources that match the entire display name given. The match is not case sensitive.
estimatedTimeInMins Number: The estimated time of the execution window in minutes.
executionResourceId String: A filter to return only resources that match the given resource id exactly.
freeformTags Map<String>: Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
id String: The OCID of the execution window.
isEnforcedDuration Boolean: Indicates if duration the user plans to allocate for scheduling window is strictly enforced. The default value is FALSE.
lifecycleDetails String: Additional information about the current lifecycle state.
lifecycleSubstate String: The current sub-state of the execution window. Valid states are DURATION_EXCEEDED, MAINTENANCE_IN_PROGRESS and WAITING.
state String: A filter to return only resources that match the given lifecycle state exactly.
timeCreated String: The date and time the execution window was created.
timeEnded String: The date and time that the execution window ended.
timeScheduled String: The scheduled start date and time of the execution window.
timeStarted String: The date and time that the execution window was started.
timeUpdated String: The last date and time that the execution window was updated.
totalTimeTakenInMins Number: The total time taken by corresponding resource activity in minutes.
windowDurationInMins Number: Duration window allows user to set a duration they plan to allocate for Scheduling window. The duration is in minutes.
windowType String: The execution window is of PLANNED or UNPLANNED type.

GetExecutionWindowsFilter

Name string
Values List<string>
Regex bool

Name string
Values []string
Regex bool

name String
values List<String>
regex Boolean

name string
values string[]
regex boolean

name str
values Sequence[str]
regex bool

name String
values List<String>
regex Boolean

Package Details

Repository: oci pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.

Oracle Cloud Infrastructure v2.32.0 published on Thursday, Apr 24, 2025 by Pulumi

pulumi/pulumi-oci

oci.Database.getExecutionWindows

On this page

On this page

Example Usage

Using getExecutionWindows

getExecutionWindows Result

Supporting Types

GetExecutionWindowsExecutionWindow

GetExecutionWindowsFilter

Package Details

On this page

On this page