JobExecution

class oci.database_management.models.JobExecution(**kwargs)

Bases: object

The details of a job execution.

Attributes:

DATABASE_SUB_TYPE_ACD

A constant which can be used with the database_sub_type property of a JobExecution.

DATABASE_SUB_TYPE_ADB

A constant which can be used with the database_sub_type property of a JobExecution.

DATABASE_SUB_TYPE_CDB

A constant which can be used with the database_sub_type property of a JobExecution.

DATABASE_SUB_TYPE_NON_CDB

A constant which can be used with the database_sub_type property of a JobExecution.

DATABASE_SUB_TYPE_PDB

A constant which can be used with the database_sub_type property of a JobExecution.

DATABASE_TYPE_CLOUD_AT_CUSTOMER

A constant which can be used with the database_type property of a JobExecution.

DATABASE_TYPE_CLOUD_RAC

A constant which can be used with the database_type property of a JobExecution.

DATABASE_TYPE_CLOUD_SIDB

A constant which can be used with the database_type property of a JobExecution.

DATABASE_TYPE_DEDICATED

A constant which can be used with the database_type property of a JobExecution.

DATABASE_TYPE_EXTERNAL_RAC

A constant which can be used with the database_type property of a JobExecution.

DATABASE_TYPE_EXTERNAL_SIDB

A constant which can be used with the database_type property of a JobExecution.

DATABASE_TYPE_SHARED

A constant which can be used with the database_type property of a JobExecution.

DEPLOYMENT_TYPE_AUTONOMOUS

A constant which can be used with the deployment_type property of a JobExecution.

DEPLOYMENT_TYPE_BM

A constant which can be used with the deployment_type property of a JobExecution.

DEPLOYMENT_TYPE_EXADATA

A constant which can be used with the deployment_type property of a JobExecution.

DEPLOYMENT_TYPE_EXADATA_CC

A constant which can be used with the deployment_type property of a JobExecution.

DEPLOYMENT_TYPE_EXADATA_XS

A constant which can be used with the deployment_type property of a JobExecution.

DEPLOYMENT_TYPE_ONPREMISE

A constant which can be used with the deployment_type property of a JobExecution.

DEPLOYMENT_TYPE_VM

A constant which can be used with the deployment_type property of a JobExecution.

STATUS_FAILED

A constant which can be used with the status property of a JobExecution.

STATUS_IN_PROGRESS

A constant which can be used with the status property of a JobExecution.

STATUS_SUCCEEDED

A constant which can be used with the status property of a JobExecution.

WORKLOAD_TYPE_AJD

A constant which can be used with the workload_type property of a JobExecution.

WORKLOAD_TYPE_APEX

A constant which can be used with the workload_type property of a JobExecution.

WORKLOAD_TYPE_DW

A constant which can be used with the workload_type property of a JobExecution.

WORKLOAD_TYPE_OLTP

A constant which can be used with the workload_type property of a JobExecution.

compartment_id

[Required] Gets the compartment_id of this JobExecution.

database_sub_type

Gets the database_sub_type of this JobExecution.

database_type

Gets the database_type of this JobExecution.

deployment_type

Gets the deployment_type of this JobExecution.

error_message

Gets the error_message of this JobExecution.

id

[Required] Gets the id of this JobExecution.

in_binds

Gets the in_binds of this JobExecution.

is_cluster

Gets the is_cluster of this JobExecution.

job_id

[Required] Gets the job_id of this JobExecution.

job_name

[Required] Gets the job_name of this JobExecution.

job_run_id

[Required] Gets the job_run_id of this JobExecution.

managed_database_group_id

Gets the managed_database_group_id of this JobExecution.

managed_database_id

[Required] Gets the managed_database_id of this JobExecution.

managed_database_name

[Required] Gets the managed_database_name of this JobExecution.

name

[Required] Gets the name of this JobExecution.

out_binds

Gets the out_binds of this JobExecution.

result_details

Gets the result_details of this JobExecution.

schedule_details

Gets the schedule_details of this JobExecution.

sql_text

Gets the sql_text of this JobExecution.

status

[Required] Gets the status of this JobExecution.

time_completed

Gets the time_completed of this JobExecution.

time_created

[Required] Gets the time_created of this JobExecution.

user_name

Gets the user_name of this JobExecution.

workload_type

Gets the workload_type of this JobExecution.

Methods:

__init__(**kwargs)

Initializes a new JobExecution object with values from keyword arguments.

DATABASE_SUB_TYPE_ACD = 'ACD'

A constant which can be used with the database_sub_type property of a JobExecution. This constant has a value of “ACD”

DATABASE_SUB_TYPE_ADB = 'ADB'

A constant which can be used with the database_sub_type property of a JobExecution. This constant has a value of “ADB”

DATABASE_SUB_TYPE_CDB = 'CDB'

A constant which can be used with the database_sub_type property of a JobExecution. This constant has a value of “CDB”

DATABASE_SUB_TYPE_NON_CDB = 'NON_CDB'

A constant which can be used with the database_sub_type property of a JobExecution. This constant has a value of “NON_CDB”

DATABASE_SUB_TYPE_PDB = 'PDB'

A constant which can be used with the database_sub_type property of a JobExecution. This constant has a value of “PDB”

DATABASE_TYPE_CLOUD_AT_CUSTOMER = 'CLOUD_AT_CUSTOMER'

A constant which can be used with the database_type property of a JobExecution. This constant has a value of “CLOUD_AT_CUSTOMER”

DATABASE_TYPE_CLOUD_RAC = 'CLOUD_RAC'

A constant which can be used with the database_type property of a JobExecution. This constant has a value of “CLOUD_RAC”

DATABASE_TYPE_CLOUD_SIDB = 'CLOUD_SIDB'

A constant which can be used with the database_type property of a JobExecution. This constant has a value of “CLOUD_SIDB”

DATABASE_TYPE_DEDICATED = 'DEDICATED'

A constant which can be used with the database_type property of a JobExecution. This constant has a value of “DEDICATED”

DATABASE_TYPE_EXTERNAL_RAC = 'EXTERNAL_RAC'

A constant which can be used with the database_type property of a JobExecution. This constant has a value of “EXTERNAL_RAC”

DATABASE_TYPE_EXTERNAL_SIDB = 'EXTERNAL_SIDB'

A constant which can be used with the database_type property of a JobExecution. This constant has a value of “EXTERNAL_SIDB”

DATABASE_TYPE_SHARED = 'SHARED'

A constant which can be used with the database_type property of a JobExecution. This constant has a value of “SHARED”

DEPLOYMENT_TYPE_AUTONOMOUS = 'AUTONOMOUS'

A constant which can be used with the deployment_type property of a JobExecution. This constant has a value of “AUTONOMOUS”

DEPLOYMENT_TYPE_BM = 'BM'

A constant which can be used with the deployment_type property of a JobExecution. This constant has a value of “BM”

DEPLOYMENT_TYPE_EXADATA = 'EXADATA'

A constant which can be used with the deployment_type property of a JobExecution. This constant has a value of “EXADATA”

DEPLOYMENT_TYPE_EXADATA_CC = 'EXADATA_CC'

A constant which can be used with the deployment_type property of a JobExecution. This constant has a value of “EXADATA_CC”

DEPLOYMENT_TYPE_EXADATA_XS = 'EXADATA_XS'

A constant which can be used with the deployment_type property of a JobExecution. This constant has a value of “EXADATA_XS”

DEPLOYMENT_TYPE_ONPREMISE = 'ONPREMISE'

A constant which can be used with the deployment_type property of a JobExecution. This constant has a value of “ONPREMISE”

DEPLOYMENT_TYPE_VM = 'VM'

A constant which can be used with the deployment_type property of a JobExecution. This constant has a value of “VM”

STATUS_FAILED = 'FAILED'

A constant which can be used with the status property of a JobExecution. This constant has a value of “FAILED”

STATUS_IN_PROGRESS = 'IN_PROGRESS'

A constant which can be used with the status property of a JobExecution. This constant has a value of “IN_PROGRESS”

STATUS_SUCCEEDED = 'SUCCEEDED'

A constant which can be used with the status property of a JobExecution. This constant has a value of “SUCCEEDED”

WORKLOAD_TYPE_AJD = 'AJD'

A constant which can be used with the workload_type property of a JobExecution. This constant has a value of “AJD”

WORKLOAD_TYPE_APEX = 'APEX'

A constant which can be used with the workload_type property of a JobExecution. This constant has a value of “APEX”

WORKLOAD_TYPE_DW = 'DW'

A constant which can be used with the workload_type property of a JobExecution. This constant has a value of “DW”

WORKLOAD_TYPE_OLTP = 'OLTP'

A constant which can be used with the workload_type property of a JobExecution. This constant has a value of “OLTP”

__init__(**kwargs)

Initializes a new JobExecution object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters
  • id (str) – The value to assign to the id property of this JobExecution.

  • name (str) – The value to assign to the name property of this JobExecution.

  • compartment_id (str) – The value to assign to the compartment_id property of this JobExecution.

  • managed_database_group_id (str) – The value to assign to the managed_database_group_id property of this JobExecution.

  • managed_database_id (str) – The value to assign to the managed_database_id property of this JobExecution.

  • managed_database_name (str) – The value to assign to the managed_database_name property of this JobExecution.

  • database_type (str) – The value to assign to the database_type property of this JobExecution. Allowed values for this property are: “EXTERNAL_SIDB”, “EXTERNAL_RAC”, “CLOUD_SIDB”, “CLOUD_RAC”, “SHARED”, “DEDICATED”, “CLOUD_AT_CUSTOMER”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

  • database_sub_type (str) – The value to assign to the database_sub_type property of this JobExecution. Allowed values for this property are: “CDB”, “PDB”, “NON_CDB”, “ACD”, “ADB”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

  • deployment_type (str) – The value to assign to the deployment_type property of this JobExecution. Allowed values for this property are: “ONPREMISE”, “BM”, “VM”, “EXADATA”, “EXADATA_CC”, “AUTONOMOUS”, “EXADATA_XS”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

  • is_cluster (bool) – The value to assign to the is_cluster property of this JobExecution.

  • workload_type (str) – The value to assign to the workload_type property of this JobExecution. Allowed values for this property are: “OLTP”, “DW”, “AJD”, “APEX”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

  • job_id (str) – The value to assign to the job_id property of this JobExecution.

  • job_name (str) – The value to assign to the job_name property of this JobExecution.

  • job_run_id (str) – The value to assign to the job_run_id property of this JobExecution.

  • status (str) – The value to assign to the status property of this JobExecution. Allowed values for this property are: “SUCCEEDED”, “FAILED”, “IN_PROGRESS”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

  • error_message (str) – The value to assign to the error_message property of this JobExecution.

  • result_details (oci.database_management.models.JobExecutionResultDetails) – The value to assign to the result_details property of this JobExecution.

  • time_created (datetime) – The value to assign to the time_created property of this JobExecution.

  • time_completed (datetime) – The value to assign to the time_completed property of this JobExecution.

  • user_name (str) – The value to assign to the user_name property of this JobExecution.

  • sql_text (str) – The value to assign to the sql_text property of this JobExecution.

  • in_binds (oci.database_management.models.JobInBindsDetails) – The value to assign to the in_binds property of this JobExecution.

  • out_binds (oci.database_management.models.JobOutBindsDetails) – The value to assign to the out_binds property of this JobExecution.

  • schedule_details (oci.database_management.models.JobScheduleDetails) – The value to assign to the schedule_details property of this JobExecution.

property compartment_id

[Required] Gets the compartment_id of this JobExecution. The OCID of the compartment in which the parent job resides.

Returns

The compartment_id of this JobExecution.

Return type

str

property database_sub_type

Gets the database_sub_type of this JobExecution. The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, or a Non-container Database.

Allowed values for this property are: “CDB”, “PDB”, “NON_CDB”, “ACD”, “ADB”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The database_sub_type of this JobExecution.

Return type

str

property database_type

Gets the database_type of this JobExecution. The type of Oracle Database installation.

Allowed values for this property are: “EXTERNAL_SIDB”, “EXTERNAL_RAC”, “CLOUD_SIDB”, “CLOUD_RAC”, “SHARED”, “DEDICATED”, “CLOUD_AT_CUSTOMER”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The database_type of this JobExecution.

Return type

str

property deployment_type

Gets the deployment_type of this JobExecution. A list of the supported infrastructure that can be used to deploy the database.

Allowed values for this property are: “ONPREMISE”, “BM”, “VM”, “EXADATA”, “EXADATA_CC”, “AUTONOMOUS”, “EXADATA_XS”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The deployment_type of this JobExecution.

Return type

str

property error_message

Gets the error_message of this JobExecution. The error message that is returned if the job execution fails. Null is returned if the job is still running or if the job execution is successful.

Returns

The error_message of this JobExecution.

Return type

str

property id

[Required] Gets the id of this JobExecution. The identifier of the job execution.

Returns

The id of this JobExecution.

Return type

str

property in_binds

Gets the in_binds of this JobExecution.

Returns

The in_binds of this JobExecution.

Return type

oci.database_management.models.JobInBindsDetails

property is_cluster

Gets the is_cluster of this JobExecution. Indicates whether the Oracle Database is part of a cluster.

Returns

The is_cluster of this JobExecution.

Return type

bool

property job_id

[Required] Gets the job_id of this JobExecution. The OCID of the parent job.

Returns

The job_id of this JobExecution.

Return type

str

property job_name

[Required] Gets the job_name of this JobExecution. The name of the parent job.

Returns

The job_name of this JobExecution.

Return type

str

property job_run_id

[Required] Gets the job_run_id of this JobExecution. The identifier of the associated job run.

Returns

The job_run_id of this JobExecution.

Return type

str

property managed_database_group_id

Gets the managed_database_group_id of this JobExecution. The OCID of the Managed Database Group where the parent job has to be executed.

Returns

The managed_database_group_id of this JobExecution.

Return type

str

property managed_database_id

[Required] Gets the managed_database_id of this JobExecution. The OCID of the Managed Database associated with the job execution.

Returns

The managed_database_id of this JobExecution.

Return type

str

property managed_database_name

[Required] Gets the managed_database_name of this JobExecution. The name of the Managed Database associated with the job execution.

Returns

The managed_database_name of this JobExecution.

Return type

str

property name

[Required] Gets the name of this JobExecution. The name of the job execution.

Returns

The name of this JobExecution.

Return type

str

property out_binds

Gets the out_binds of this JobExecution.

Returns

The out_binds of this JobExecution.

Return type

oci.database_management.models.JobOutBindsDetails

property result_details

Gets the result_details of this JobExecution.

Returns

The result_details of this JobExecution.

Return type

oci.database_management.models.JobExecutionResultDetails

property schedule_details

Gets the schedule_details of this JobExecution.

Returns

The schedule_details of this JobExecution.

Return type

oci.database_management.models.JobScheduleDetails

property sql_text

Gets the sql_text of this JobExecution. The SQL text executed as part of the job.

Returns

The sql_text of this JobExecution.

Return type

str

property status

[Required] Gets the status of this JobExecution. The status of the job execution.

Allowed values for this property are: “SUCCEEDED”, “FAILED”, “IN_PROGRESS”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The status of this JobExecution.

Return type

str

property time_completed

Gets the time_completed of this JobExecution. The date and time when the job execution completed.

Returns

The time_completed of this JobExecution.

Return type

datetime

property time_created

[Required] Gets the time_created of this JobExecution. The date and time when the job execution was created.

Returns

The time_created of this JobExecution.

Return type

datetime

property user_name

Gets the user_name of this JobExecution. The database user name used to execute the SQL job.

Returns

The user_name of this JobExecution.

Return type

str

property workload_type

Gets the workload_type of this JobExecution. The workload type of the Autonomous Database.

Allowed values for this property are: “OLTP”, “DW”, “AJD”, “APEX”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The workload_type of this JobExecution.

Return type

str