Data Source: oci_database_management_managed_database_sql_plan_baseline_jobs
This data source provides the list of Managed Database Sql Plan Baseline Jobs in Oracle Cloud Infrastructure Database Management service.
Lists the database jobs used for loading SQL plan baselines in the specified Managed Database.
Example Usage
data "oci_database_management_managed_database_sql_plan_baseline_jobs" "test_managed_database_sql_plan_baseline_jobs" {
#Required
managed_database_id = oci_database_management_managed_database.test_managed_database.id
#Optional
name = var.managed_database_sql_plan_baseline_job_name
opc_named_credential_id = var.managed_database_sql_plan_baseline_job_opc_named_credential_id
}
Argument Reference
The following arguments are supported:
managed_database_id
- (Required) The OCID of the Managed Database.name
- (Optional) A filter to return the SQL plan baseline jobs that match the name.opc_named_credential_id
- (Optional) The OCID of the Named Credential.
Attributes Reference
The following attributes are exported:
sql_plan_baseline_job_collection
- The list of sql_plan_baseline_job_collection.
ManagedDatabaseSqlPlanBaselineJob Reference
The following attributes are exported:
items
- A list of SQL plan baseline jobs.name
- The name of the job.status
- The status of the job.time_created
- The date and time the job was created.type
- The type of the job.