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