Data Source: oci_database_migration_jobs

This data source provides the list of Jobs in Oracle Cloud Infrastructure Database Migration service.

List all the names of the Migration jobs associated to the specified migration site.

Note: If you wish to use the DMS deprecated API version /20210929 it is necessary to pin the Terraform Provider version to v5.47.0. Newer Terraform provider versions will not support the DMS deprecated API version /20210929

Example Usage

data "oci_database_migration_jobs" "test_jobs" {
	#Required
	migration_id = oci_database_migration_migration.test_migration.id

	#Optional
	display_name = var.job_display_name
	state = var.job_state
}

Argument Reference

The following arguments are supported:

• display_name - (Optional) A filter to return only resources that match the entire display name given.
• migration_id - (Required) The ID of the migration in which to list resources.
• state - (Optional) The lifecycle state of the Migration Job.

Attributes Reference

The following attributes are exported:

• job_collection - The list of job_collection.

Job Reference

The following attributes are exported:

• defined_tags - Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
• display_name - Name of the job.
• freeform_tags - Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {“Department”: “Finance”}
• id - The OCID of the Migration Job.
• lifecycle_details - A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
• migration_id - The OCID of the Migration that this job belongs to.
• parameter_file_versions - A list of parameter file versions that can be viewed or edited for the current job.
  • defined_tags - Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
  • description - A description to discribe the current parameter file version
  • freeform_tags - Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {“Department”: “Finance”}
  • is_current - Return boolean true/false for the currently in-use parameter file (factory or a versioned file)
  • is_factory - Return true/false for whether the parameter file is oracle provided (Factory)
  • kind - Indicator of Parameter File ‘kind’ (for an EXTRACT or a REPLICAT)
  • name - A unique name associated with the current migration/job and extract/replicat name
  • system_tags - Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
  • time_created - The time when this parameter file was applied on the process
• progress - Progress details of a Migration Job.
  • current_phase - Current phase of the job.
  • current_status - Current status of the job.
  • phases - List of phase status for the job.
    • action - The text describing the action required to fix the issue
    • duration_in_ms - Duration of the phase in milliseconds
    • editable_parameter_files - Attribute that returns an array of names and types of GoldenGate configuration files that are available for read or update.
    • extract - Summary of phase status results.
      • message - Message in entry.
      • type - Type of extract.
    • is_advisor_report_available - True if a Pre-Migration Advisor report is available for this phase. False or null if no report is available.
    • is_suspend_available - This is returned as true if the current phase can be suspended.
    • issue - The text describing the root cause of the reported issue
    • log_location - Details to access log file in the specified Object Storage bucket, if any.
      • bucket - Name of the bucket containing the log file.
      • namespace - Object Storage namespace.
      • object - Log object name.
    • name - Phase name
    • progress - Percent progress of job phase.
    • status - Phase status
• state - The current state of the migration job.
• system_tags - Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
• time_created - The time the Migration Job was created. An RFC3339 formatted datetime string
• time_updated - The time the Migration Job was last updated. An RFC3339 formatted datetime string
• type - The job type.
• unsupported_objects - Database objects not supported.
  • object - Name of the object (regular expression is allowed)
  • owner - Owner of the object (regular expression is allowed)
  • type - Type of unsupported object