oci.DatabaseManagement.getJobExecutionsStatuses
Explore with Pulumi AI
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,
});
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)
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
	})
}
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,
    });
});
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());
    }
}
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}
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)
public static Output<GetJobExecutionsStatusesResult> getJobExecutionsStatuses(GetJobExecutionsStatusesArgs args, InvokeOptions options)
fn::invoke:
  function: oci:DatabaseManagement/getJobExecutionsStatuses:getJobExecutionsStatuses
  arguments:
    # arguments dictionaryThe 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<GetJob Executions Statuses Filter> 
- Id string
- The identifier of the resource.
- ManagedDatabase stringGroup Id 
- The OCID of the Managed Database Group.
- ManagedDatabase stringId 
- 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
[]GetJob Executions Statuses Filter 
- Id string
- The identifier of the resource.
- ManagedDatabase stringGroup Id 
- The OCID of the Managed Database Group.
- ManagedDatabase stringId 
- 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<GetJob Executions Statuses Filter> 
- id String
- The identifier of the resource.
- managedDatabase StringGroup Id 
- The OCID of the Managed Database Group.
- managedDatabase StringId 
- 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
GetJob Executions Statuses Filter[] 
- id string
- The identifier of the resource.
- managedDatabase stringGroup Id 
- The OCID of the Managed Database Group.
- managedDatabase stringId 
- 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
Sequence[databasemanagement.Get Job Executions Statuses Filter] 
- id str
- The identifier of the resource.
- managed_database_ strgroup_ id 
- The OCID of the Managed Database Group.
- managed_database_ strid 
- 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.
- managedDatabase StringGroup Id 
- The OCID of the Managed Database Group.
- managedDatabase StringId 
- 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
- JobExecutions List<GetStatus Summary Collections Job Executions Statuses Job Executions Status Summary Collection> 
- The list of job_executions_status_summary_collection.
- StartTime string
- Filters
List<GetJob Executions Statuses Filter> 
- Id string
- ManagedDatabase stringGroup Id 
- ManagedDatabase stringId 
- Name string
- CompartmentId string
- EndTime string
- JobExecutions []GetStatus Summary Collections Job Executions Statuses Job Executions Status Summary Collection 
- The list of job_executions_status_summary_collection.
- StartTime string
- Filters
[]GetJob Executions Statuses Filter 
- Id string
- ManagedDatabase stringGroup Id 
- ManagedDatabase stringId 
- Name string
- compartmentId String
- endTime String
- jobExecutions List<GetStatus Summary Collections Job Executions Statuses Job Executions Status Summary Collection> 
- The list of job_executions_status_summary_collection.
- startTime String
- filters
List<GetJob Executions Statuses Filter> 
- id String
- managedDatabase StringGroup Id 
- managedDatabase StringId 
- name String
- compartmentId string
- endTime string
- jobExecutions GetStatus Summary Collections Job Executions Statuses Job Executions Status Summary Collection[] 
- The list of job_executions_status_summary_collection.
- startTime string
- filters
GetJob Executions Statuses Filter[] 
- id string
- managedDatabase stringGroup Id 
- managedDatabase stringId 
- name string
- compartment_id str
- end_time str
- job_executions_ Sequence[databasemanagement.status_ summary_ collections Get Job Executions Statuses Job Executions Status Summary Collection] 
- The list of job_executions_status_summary_collection.
- start_time str
- filters
Sequence[databasemanagement.Get Job Executions Statuses Filter] 
- id str
- managed_database_ strgroup_ id 
- managed_database_ strid 
- name str
- compartmentId String
- endTime String
- jobExecutions List<Property Map>Status Summary Collections 
- The list of job_executions_status_summary_collection.
- startTime String
- filters List<Property Map>
- id String
- managedDatabase StringGroup Id 
- managedDatabase StringId 
- name String
Supporting Types
GetJobExecutionsStatusesFilter    
GetJobExecutionsStatusesJobExecutionsStatusSummaryCollection        
- Items
List<GetJob Executions Statuses Job Executions Status Summary Collection Item> 
- A list of JobExecutionsSummary objects.
- Items
[]GetJob Executions Statuses Job Executions Status Summary Collection Item 
- A list of JobExecutionsSummary objects.
- items
List<GetJob Executions Statuses Job Executions Status Summary Collection Item> 
- A list of JobExecutionsSummary objects.
- items
GetJob Executions Statuses Job Executions Status Summary Collection Item[] 
- A list of JobExecutionsSummary objects.
- items
Sequence[databasemanagement.Get Job Executions Statuses Job Executions Status Summary Collection Item] 
- A list of JobExecutionsSummary objects.
- items List<Property Map>
- A list of JobExecutionsSummary objects.
GetJobExecutionsStatusesJobExecutionsStatusSummaryCollectionItem         
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the ociTerraform Provider.