1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getJobExecutionsStatuses
Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi

oci.DatabaseManagement.getJobExecutionsStatuses

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi

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

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

const testJobExecutionsStatuses = oci.DatabaseManagement.getJobExecutionsStatuses({
    compartmentId: compartmentId,
    endTime: jobExecutionsStatusEndTime,
    startTime: jobExecutionsStatusStartTime,
    id: jobExecutionsStatusId,
    managedDatabaseGroupId: testManagedDatabaseGroup.id,
    managedDatabaseId: testManagedDatabase.id,
    name: jobExecutionsStatusName,
});
Copy
import pulumi
import pulumi_oci as oci

test_job_executions_statuses = oci.DatabaseManagement.get_job_executions_statuses(compartment_id=compartment_id,
    end_time=job_executions_status_end_time,
    start_time=job_executions_status_start_time,
    id=job_executions_status_id,
    managed_database_group_id=test_managed_database_group["id"],
    managed_database_id=test_managed_database["id"],
    name=job_executions_status_name)
Copy
package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/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:          compartmentId,
			EndTime:                jobExecutionsStatusEndTime,
			StartTime:              jobExecutionsStatusStartTime,
			Id:                     pulumi.StringRef(jobExecutionsStatusId),
			ManagedDatabaseGroupId: pulumi.StringRef(testManagedDatabaseGroup.Id),
			ManagedDatabaseId:      pulumi.StringRef(testManagedDatabase.Id),
			Name:                   pulumi.StringRef(jobExecutionsStatusName),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
Copy
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testJobExecutionsStatuses = Oci.DatabaseManagement.GetJobExecutionsStatuses.Invoke(new()
    {
        CompartmentId = compartmentId,
        EndTime = jobExecutionsStatusEndTime,
        StartTime = jobExecutionsStatusStartTime,
        Id = jobExecutionsStatusId,
        ManagedDatabaseGroupId = testManagedDatabaseGroup.Id,
        ManagedDatabaseId = testManagedDatabase.Id,
        Name = jobExecutionsStatusName,
    });

});
Copy
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.GetJobExecutionsStatusesArgs;
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 testJobExecutionsStatuses = DatabaseManagementFunctions.getJobExecutionsStatuses(GetJobExecutionsStatusesArgs.builder()
            .compartmentId(compartmentId)
            .endTime(jobExecutionsStatusEndTime)
            .startTime(jobExecutionsStatusStartTime)
            .id(jobExecutionsStatusId)
            .managedDatabaseGroupId(testManagedDatabaseGroup.id())
            .managedDatabaseId(testManagedDatabase.id())
            .name(jobExecutionsStatusName)
            .build());

    }
}
Copy
variables:
  testJobExecutionsStatuses:
    fn::invoke:
      function: oci:DatabaseManagement:getJobExecutionsStatuses
      arguments:
        compartmentId: ${compartmentId}
        endTime: ${jobExecutionsStatusEndTime}
        startTime: ${jobExecutionsStatusStartTime}
        id: ${jobExecutionsStatusId}
        managedDatabaseGroupId: ${testManagedDatabaseGroup.id}
        managedDatabaseId: ${testManagedDatabase.id}
        name: ${jobExecutionsStatusName}
Copy

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>
Copy
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]
Copy
func GetJobExecutionsStatuses(ctx *Context, args *GetJobExecutionsStatusesArgs, opts ...InvokeOption) (*GetJobExecutionsStatusesResult, error)
func GetJobExecutionsStatusesOutput(ctx *Context, args *GetJobExecutionsStatusesOutputArgs, opts ...InvokeOption) GetJobExecutionsStatusesResultOutput
Copy

> 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)
}
Copy
public static CompletableFuture<GetJobExecutionsStatusesResult> getJobExecutionsStatuses(GetJobExecutionsStatusesArgs args, InvokeOptions options)
public static Output<GetJobExecutionsStatusesResult> getJobExecutionsStatuses(GetJobExecutionsStatusesArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:DatabaseManagement/getJobExecutionsStatuses:getJobExecutionsStatuses
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

CompartmentId This property is required. string
The OCID of the compartment.
EndTime This property is required. 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 This property is required. 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 Changes to this property will trigger replacement. 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 This property is required. string
The OCID of the compartment.
EndTime This property is required. 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 This property is required. 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 Changes to this property will trigger replacement. []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 This property is required. String
The OCID of the compartment.
endTime This property is required. 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 This property is required. 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 Changes to this property will trigger replacement. 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 This property is required. string
The OCID of the compartment.
endTime This property is required. 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 This property is required. 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 Changes to this property will trigger replacement. 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 This property is required. str
The OCID of the compartment.
end_time This property is required. 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 This property is required. 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 Changes to this property will trigger replacement. Sequence[databasemanagement.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 This property is required. String
The OCID of the compartment.
endTime This property is required. 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 This property is required. 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 Changes to this property will trigger replacement. 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 This property is required. string
A filter to return only resources that match the entire name.
Values This property is required. List<string>
Regex bool
Name This property is required. string
A filter to return only resources that match the entire name.
Values This property is required. []string
Regex bool
name This property is required. String
A filter to return only resources that match the entire name.
values This property is required. List<String>
regex Boolean
name This property is required. string
A filter to return only resources that match the entire name.
values This property is required. string[]
regex boolean
name This property is required. str
A filter to return only resources that match the entire name.
values This property is required. Sequence[str]
regex bool
name This property is required. String
A filter to return only resources that match the entire name.
values This property is required. List<String>
regex Boolean

GetJobExecutionsStatusesJobExecutionsStatusSummaryCollection

Items This property is required. List<GetJobExecutionsStatusesJobExecutionsStatusSummaryCollectionItem>
A list of JobExecutionsSummary objects.
Items This property is required. []GetJobExecutionsStatusesJobExecutionsStatusSummaryCollectionItem
A list of JobExecutionsSummary objects.
items This property is required. List<GetJobExecutionsStatusesJobExecutionsStatusSummaryCollectionItem>
A list of JobExecutionsSummary objects.
items This property is required. GetJobExecutionsStatusesJobExecutionsStatusSummaryCollectionItem[]
A list of JobExecutionsSummary objects.
items This property is required. Sequence[databasemanagement.GetJobExecutionsStatusesJobExecutionsStatusSummaryCollectionItem]
A list of JobExecutionsSummary objects.
items This property is required. List<Property Map>
A list of JobExecutionsSummary objects.

GetJobExecutionsStatusesJobExecutionsStatusSummaryCollectionItem

Count This property is required. int
The number of job executions of a particular status.
Status This property is required. string
The status of the job execution.
Count This property is required. int
The number of job executions of a particular status.
Status This property is required. string
The status of the job execution.
count This property is required. Integer
The number of job executions of a particular status.
status This property is required. String
The status of the job execution.
count This property is required. number
The number of job executions of a particular status.
status This property is required. string
The status of the job execution.
count This property is required. int
The number of job executions of a particular status.
status This property is required. str
The status of the job execution.
count This property is required. Number
The number of job executions of a particular status.
status This property is required. String
The status of the job execution.

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.30.0 published on Monday, Apr 14, 2025 by Pulumi