Oracle Cloud Infrastructure

v0.5.0 published on Monday, Sep 12, 2022 by Pulumi

getJobExecutionsStatus

This data source provides details about a specific Job Executions Status resource 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 System.Collections.Generic;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testJobExecutionsStatus = Oci.DatabaseManagement.GetJobExecutionsStatus.Invoke(new()
    {
        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.GetJobExecutionsStatus(ctx, &databasemanagement.GetJobExecutionsStatusArgs{
			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
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseManagement.DatabaseManagementFunctions;
import com.pulumi.oci.DatabaseManagement.inputs.GetJobExecutionsStatusArgs;
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 testJobExecutionsStatus = DatabaseManagementFunctions.getJobExecutionsStatus(GetJobExecutionsStatusArgs.builder()
            .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())
            .build());

    }
}

import pulumi
import pulumi_oci as oci

test_job_executions_status = oci.DatabaseManagement.get_job_executions_status(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 testJobExecutionsStatus = oci.DatabaseManagement.getJobExecutionsStatus({
    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,
});

variables:
  testJobExecutionsStatus:
    Fn::Invoke:
      Function: oci:DatabaseManagement:getJobExecutionsStatus
      Arguments:
        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}

Using getJobExecutionsStatus

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 getJobExecutionsStatus(args: GetJobExecutionsStatusArgs, opts?: InvokeOptions): Promise<GetJobExecutionsStatusResult>
function getJobExecutionsStatusOutput(args: GetJobExecutionsStatusOutputArgs, opts?: InvokeOptions): Output<GetJobExecutionsStatusResult>

def get_job_executions_status(compartment_id: Optional[str] = None,
                              end_time: Optional[str] = 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) -> GetJobExecutionsStatusResult
def get_job_executions_status_output(compartment_id: Optional[pulumi.Input[str]] = None,
                              end_time: Optional[pulumi.Input[str]] = 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[GetJobExecutionsStatusResult]

func GetJobExecutionsStatus(ctx *Context, args *GetJobExecutionsStatusArgs, opts ...InvokeOption) (*GetJobExecutionsStatusResult, error)
func GetJobExecutionsStatusOutput(ctx *Context, args *GetJobExecutionsStatusOutputArgs, opts ...InvokeOption) GetJobExecutionsStatusResultOutput

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

public static class GetJobExecutionsStatus 
{
    public static Task<GetJobExecutionsStatusResult> InvokeAsync(GetJobExecutionsStatusArgs args, InvokeOptions? opts = null)
    public static Output<GetJobExecutionsStatusResult> Invoke(GetJobExecutionsStatusInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetJobExecutionsStatusResult> getJobExecutionsStatus(GetJobExecutionsStatusArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

fn::invoke:
  function: oci:DatabaseManagement/getJobExecutionsStatus:getJobExecutionsStatus
  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'".
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'".
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'".
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'".
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'".
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'".
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.