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_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_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”, ‘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.
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
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
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”, ‘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
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
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
id

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

Returns:The id of this JobExecution.
Return type:str
in_binds

Gets the in_binds of this JobExecution.

Returns:The in_binds of this JobExecution.
Return type:oci.database_management.models.JobInBindsDetails
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
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
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
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
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
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
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
name

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

Returns:The name of this JobExecution.
Return type:str
out_binds

Gets the out_binds of this JobExecution.

Returns:The out_binds of this JobExecution.
Return type:oci.database_management.models.JobOutBindsDetails
result_details

Gets the result_details of this JobExecution.

Returns:The result_details of this JobExecution.
Return type:oci.database_management.models.JobExecutionResultDetails
schedule_details

Gets the schedule_details of this JobExecution.

Returns:The schedule_details of this JobExecution.
Return type:oci.database_management.models.JobScheduleDetails
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
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
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
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
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
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