oci.DatabaseManagement.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
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/v3/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[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[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:
- 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[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[Getstatus_ summary_ collections Job Executions Statuses Job Executions Status Summary Collection] - The list of job_executions_status_summary_collection.
- start_
time str - filters
Sequence[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[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.
