Oracle Cloud Infrastructure

Pulumi Official
Package maintained by Pulumi
v0.1.1 published on Tuesday, May 3, 2022 by Pulumi

getJobExecutionsStatuses

This data source provides the list of Job Executions Statuses in Oracle Cloud Infrastructure Database Management service.

Gets the number of job executions grouped by status for a job, Managed Database, or Database Group in a specific compartment. Only one of the parameters, jobId, managedDatabaseId, or managedDatabaseGroupId should be provided.

Example Usage

using Pulumi;
using Oci = Pulumi.Oci;

class MyStack : Stack
{
    public MyStack()
    {
        var testJobExecutionsStatuses = Output.Create(Oci.DatabaseManagement.GetJobExecutionsStatuses.InvokeAsync(new Oci.DatabaseManagement.GetJobExecutionsStatusesArgs
        {
            CompartmentId = @var.Compartment_id,
            EndTime = @var.Job_executions_status_end_time,
            StartTime = @var.Job_executions_status_start_time,
            Id = @var.Job_executions_status_id,
            ManagedDatabaseGroupId = oci_database_management_managed_database_group.Test_managed_database_group.Id,
            ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
            Name = @var.Job_executions_status_name,
        }));
    }

}
package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := DatabaseManagement.GetJobExecutionsStatuses(ctx, &databasemanagement.GetJobExecutionsStatusesArgs{
			CompartmentId:          _var.Compartment_id,
			EndTime:                _var.Job_executions_status_end_time,
			StartTime:              _var.Job_executions_status_start_time,
			Id:                     pulumi.StringRef(_var.Job_executions_status_id),
			ManagedDatabaseGroupId: pulumi.StringRef(oci_database_management_managed_database_group.Test_managed_database_group.Id),
			ManagedDatabaseId:      pulumi.StringRef(oci_database_management_managed_database.Test_managed_database.Id),
			Name:                   pulumi.StringRef(_var.Job_executions_status_name),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

Coming soon!

import pulumi
import pulumi_oci as oci

test_job_executions_statuses = oci.DatabaseManagement.get_job_executions_statuses(compartment_id=var["compartment_id"],
    end_time=var["job_executions_status_end_time"],
    start_time=var["job_executions_status_start_time"],
    id=var["job_executions_status_id"],
    managed_database_group_id=oci_database_management_managed_database_group["test_managed_database_group"]["id"],
    managed_database_id=oci_database_management_managed_database["test_managed_database"]["id"],
    name=var["job_executions_status_name"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testJobExecutionsStatuses = oci.DatabaseManagement.getJobExecutionsStatuses({
    compartmentId: _var.compartment_id,
    endTime: _var.job_executions_status_end_time,
    startTime: _var.job_executions_status_start_time,
    id: _var.job_executions_status_id,
    managedDatabaseGroupId: oci_database_management_managed_database_group.test_managed_database_group.id,
    managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
    name: _var.job_executions_status_name,
});

Coming soon!

Using getJobExecutionsStatuses

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.

function getJobExecutionsStatuses(args: GetJobExecutionsStatusesArgs, opts?: InvokeOptions): Promise<GetJobExecutionsStatusesResult>
function getJobExecutionsStatusesOutput(args: GetJobExecutionsStatusesOutputArgs, opts?: InvokeOptions): Output<GetJobExecutionsStatusesResult>
def get_job_executions_statuses(compartment_id: Optional[str] = None,
                                end_time: Optional[str] = None,
                                filters: Optional[Sequence[_databasemanagement.GetJobExecutionsStatusesFilter]] = None,
                                id: Optional[str] = None,
                                managed_database_group_id: Optional[str] = None,
                                managed_database_id: Optional[str] = None,
                                name: Optional[str] = None,
                                start_time: Optional[str] = None,
                                opts: Optional[InvokeOptions] = None) -> GetJobExecutionsStatusesResult
def get_job_executions_statuses_output(compartment_id: Optional[pulumi.Input[str]] = None,
                                end_time: Optional[pulumi.Input[str]] = None,
                                filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetJobExecutionsStatusesFilterArgs]]]] = None,
                                id: Optional[pulumi.Input[str]] = None,
                                managed_database_group_id: Optional[pulumi.Input[str]] = None,
                                managed_database_id: Optional[pulumi.Input[str]] = None,
                                name: Optional[pulumi.Input[str]] = None,
                                start_time: Optional[pulumi.Input[str]] = None,
                                opts: Optional[InvokeOptions] = None) -> Output[GetJobExecutionsStatusesResult]
func GetJobExecutionsStatuses(ctx *Context, args *GetJobExecutionsStatusesArgs, opts ...InvokeOption) (*GetJobExecutionsStatusesResult, error)
func GetJobExecutionsStatusesOutput(ctx *Context, args *GetJobExecutionsStatusesOutputArgs, opts ...InvokeOption) GetJobExecutionsStatusesResultOutput

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

public static class GetJobExecutionsStatuses 
{
    public static Task<GetJobExecutionsStatusesResult> InvokeAsync(GetJobExecutionsStatusesArgs args, InvokeOptions? opts = null)
    public static Output<GetJobExecutionsStatusesResult> Invoke(GetJobExecutionsStatusesInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetJobExecutionsStatusesResult> getJobExecutionsStatuses(GetJobExecutionsStatusesArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
Fn::Invoke:
  Function: oci:DatabaseManagement/getJobExecutionsStatuses:getJobExecutionsStatuses
  Arguments:
    # Arguments dictionary

The following arguments are supported:

CompartmentId string

The OCID of the compartment.

EndTime string

The end time of the time range to retrieve the status summary of job executions in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

StartTime string

The start time of the time range to retrieve the status summary of job executions in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

Filters List<GetJobExecutionsStatusesFilter>
Id string

The identifier of the resource.

ManagedDatabaseGroupId string

The OCID of the Managed Database Group.

ManagedDatabaseId string

The OCID of the Managed Database.

Name string

A filter to return only resources that match the entire name.

CompartmentId string

The OCID of the compartment.

EndTime string

The end time of the time range to retrieve the status summary of job executions in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

StartTime string

The start time of the time range to retrieve the status summary of job executions in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

Filters []GetJobExecutionsStatusesFilter
Id string

The identifier of the resource.

ManagedDatabaseGroupId string

The OCID of the Managed Database Group.

ManagedDatabaseId string

The OCID of the Managed Database.

Name string

A filter to return only resources that match the entire name.

compartmentId String

The OCID of the compartment.

endTime String

The end time of the time range to retrieve the status summary of job executions in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

startTime String

The start time of the time range to retrieve the status summary of job executions in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

filters List<GetJobExecutionsStatusesFilter>
id String

The identifier of the resource.

managedDatabaseGroupId String

The OCID of the Managed Database Group.

managedDatabaseId String

The OCID of the Managed Database.

name String

A filter to return only resources that match the entire name.

compartmentId string

The OCID of the compartment.

endTime string

The end time of the time range to retrieve the status summary of job executions in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

startTime string

The start time of the time range to retrieve the status summary of job executions in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

filters GetJobExecutionsStatusesFilter[]
id string

The identifier of the resource.

managedDatabaseGroupId string

The OCID of the Managed Database Group.

managedDatabaseId string

The OCID of the Managed Database.

name string

A filter to return only resources that match the entire name.

compartment_id str

The OCID of the compartment.

end_time str

The end time of the time range to retrieve the status summary of job executions in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

start_time str

The start time of the time range to retrieve the status summary of job executions in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

filters GetJobExecutionsStatusesFilter]
id str

The identifier of the resource.

managed_database_group_id str

The OCID of the Managed Database Group.

managed_database_id str

The OCID of the Managed Database.

name str

A filter to return only resources that match the entire name.

compartmentId String

The OCID of the compartment.

endTime String

The end time of the time range to retrieve the status summary of job executions in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

startTime String

The start time of the time range to retrieve the status summary of job executions in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

filters List<Property Map>
id String

The identifier of the resource.

managedDatabaseGroupId String

The OCID of the Managed Database Group.

managedDatabaseId String

The OCID of the Managed Database.

name String

A filter to return only resources that match the entire name.

getJobExecutionsStatuses Result

The following output properties are available:

compartmentId String
endTime String
jobExecutionsStatusSummaryCollections List<Property Map>

The list of job_executions_status_summary_collection.

startTime String
filters List<Property Map>
id String
managedDatabaseGroupId String
managedDatabaseId String
name String

Supporting Types

GetJobExecutionsStatusesFilter

Name string

A filter to return only resources that match the entire name.

Values List<string>
Regex bool
Name string

A filter to return only resources that match the entire name.

Values []string
Regex bool
name String

A filter to return only resources that match the entire name.

values List<String>
regex Boolean
name string

A filter to return only resources that match the entire name.

values string[]
regex boolean
name str

A filter to return only resources that match the entire name.

values Sequence[str]
regex bool
name String

A filter to return only resources that match the entire name.

values List<String>
regex Boolean

GetJobExecutionsStatusesJobExecutionsStatusSummaryCollection

items List<Property Map>

A list of JobExecutionsSummary objects.

GetJobExecutionsStatusesJobExecutionsStatusSummaryCollectionItem

Count int

The number of job executions of a particular status.

Status string

The status of the job execution.

Count int

The number of job executions of a particular status.

Status string

The status of the job execution.

count Integer

The number of job executions of a particular status.

status String

The status of the job execution.

count number

The number of job executions of a particular status.

status string

The status of the job execution.

count int

The number of job executions of a particular status.

status str

The status of the job execution.

count Number

The number of job executions of a particular status.

status String

The status of the job execution.

Package Details

Repository
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.