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)
// Output-based functions aren't available in Java yet
fn::invoke:
function: oci:DatabaseManagement/getJobExecutionsStatuses:getJobExecutionsStatuses
arguments:
# arguments dictionary
The following arguments are supported:
- Compartment
Id string - The OCID of the compartment.
- End
Time 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'".
- Start
Time 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<Get
Job Executions Statuses Filter> - Id string
- The identifier of the resource.
- Managed
Database stringGroup Id - The OCID of the Managed Database Group.
- Managed
Database stringId - The OCID of the Managed Database.
- Name string
- A filter to return only resources that match the entire name.
- Compartment
Id string - The OCID of the compartment.
- End
Time 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'".
- Start
Time 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
[]Get
Job Executions Statuses Filter - Id string
- The identifier of the resource.
- Managed
Database stringGroup Id - The OCID of the Managed Database Group.
- Managed
Database stringId - The OCID of the Managed Database.
- Name string
- A filter to return only resources that match the entire name.
- compartment
Id String - The OCID of the compartment.
- end
Time 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'".
- start
Time 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<Get
Job Executions Statuses Filter> - id String
- The identifier of the resource.
- managed
Database StringGroup Id - The OCID of the Managed Database Group.
- managed
Database StringId - The OCID of the Managed Database.
- name String
- A filter to return only resources that match the entire name.
- compartment
Id string - The OCID of the compartment.
- end
Time 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'".
- start
Time 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
Get
Job Executions Statuses Filter[] - id string
- The identifier of the resource.
- managed
Database stringGroup Id - The OCID of the Managed Database Group.
- managed
Database 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.
- compartment
Id String - The OCID of the compartment.
- end
Time 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'".
- start
Time 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.
- managed
Database StringGroup Id - The OCID of the Managed Database Group.
- managed
Database 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:
- Compartment
Id string - End
Time string - Job
Executions List<GetStatus Summary Collections Job Executions Statuses Job Executions Status Summary Collection> - The list of job_executions_status_summary_collection.
- Start
Time string - Filters
List<Get
Job Executions Statuses Filter> - Id string
- Managed
Database stringGroup Id - Managed
Database stringId - Name string
- Compartment
Id string - End
Time string - Job
Executions []GetStatus Summary Collections Job Executions Statuses Job Executions Status Summary Collection - The list of job_executions_status_summary_collection.
- Start
Time string - Filters
[]Get
Job Executions Statuses Filter - Id string
- Managed
Database stringGroup Id - Managed
Database stringId - Name string
- compartment
Id String - end
Time String - job
Executions List<GetStatus Summary Collections Job Executions Statuses Job Executions Status Summary Collection> - The list of job_executions_status_summary_collection.
- start
Time String - filters
List<Get
Job Executions Statuses Filter> - id String
- managed
Database StringGroup Id - managed
Database StringId - name String
- compartment
Id string - end
Time string - job
Executions GetStatus Summary Collections Job Executions Statuses Job Executions Status Summary Collection[] - The list of job_executions_status_summary_collection.
- start
Time string - filters
Get
Job Executions Statuses Filter[] - id string
- managed
Database stringGroup Id - managed
Database 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
- compartment
Id String - end
Time String - job
Executions List<Property Map>Status Summary Collections - The list of job_executions_status_summary_collection.
- start
Time String - filters List<Property Map>
- id String
- managed
Database StringGroup Id - managed
Database StringId - name String
Supporting Types
GetJobExecutionsStatusesFilter
GetJobExecutionsStatusesJobExecutionsStatusSummaryCollection
- Items
List<Get
Job Executions Statuses Job Executions Status Summary Collection Item> - A list of JobExecutionsSummary objects.
- Items
[]Get
Job Executions Statuses Job Executions Status Summary Collection Item - A list of JobExecutionsSummary objects.
- items
List<Get
Job Executions Statuses Job Executions Status Summary Collection Item> - A list of JobExecutionsSummary objects.
- items
Get
Job 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
oci
Terraform Provider.