UpdateSqlJobDetails¶
-
class
oci.database_management.models.
UpdateSqlJobDetails
(**kwargs)¶ Bases:
oci.database_management.models.update_job_details.UpdateJobDetails
The details specific to the SQL job request.
Attributes
JOB_TYPE_SQL
str(object=’’) -> str description
Gets the description of this UpdateJobDetails. job_type
Gets the job_type of this UpdateJobDetails. password
Gets the password of this UpdateSqlJobDetails. result_location
Gets the result_location of this UpdateJobDetails. role
Gets the role of this UpdateSqlJobDetails. schedule_details
Gets the schedule_details of this UpdateJobDetails. secret_id
Gets the secret_id of this UpdateSqlJobDetails. sql_text
Gets the sql_text of this UpdateSqlJobDetails. sql_type
Gets the sql_type of this UpdateSqlJobDetails. timeout
Gets the timeout of this UpdateJobDetails. user_name
Gets the user_name of this UpdateSqlJobDetails. Methods
__init__
(**kwargs)Initializes a new UpdateSqlJobDetails object with values from keyword arguments. get_subtype
(object_dictionary)Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype. -
JOB_TYPE_SQL
= 'SQL'¶
-
__init__
(**kwargs)¶ Initializes a new UpdateSqlJobDetails object with values from keyword arguments. The default value of the
job_type
attribute of this class isSQL
and it should not be changed. The following keyword arguments are supported (corresponding to the getters/setters of this class):Parameters: - description (str) – The value to assign to the description property of this UpdateSqlJobDetails.
- job_type (str) – The value to assign to the job_type property of this UpdateSqlJobDetails. Allowed values for this property are: “SQL”
- timeout (str) – The value to assign to the timeout property of this UpdateSqlJobDetails.
- result_location (oci.database_management.models.JobExecutionResultLocation) – The value to assign to the result_location property of this UpdateSqlJobDetails.
- schedule_details (oci.database_management.models.JobScheduleDetails) – The value to assign to the schedule_details property of this UpdateSqlJobDetails.
- sql_text (str) – The value to assign to the sql_text property of this UpdateSqlJobDetails.
- sql_type (str) – The value to assign to the sql_type property of this UpdateSqlJobDetails.
- user_name (str) – The value to assign to the user_name property of this UpdateSqlJobDetails.
- password (str) – The value to assign to the password property of this UpdateSqlJobDetails.
- secret_id (str) – The value to assign to the secret_id property of this UpdateSqlJobDetails.
- role (str) – The value to assign to the role property of this UpdateSqlJobDetails.
-
description
¶ Gets the description of this UpdateJobDetails. The description of the job.
Returns: The description of this UpdateJobDetails. Return type: str
-
static
get_subtype
(object_dictionary)¶ Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.
-
job_type
¶ Gets the job_type of this UpdateJobDetails. The type of job.
Allowed values for this property are: “SQL”
Returns: The job_type of this UpdateJobDetails. Return type: str
-
password
¶ Gets the password of this UpdateSqlJobDetails. The password for the database user name used to execute the SQL job.
Returns: The password of this UpdateSqlJobDetails. Return type: str
-
result_location
¶ Gets the result_location of this UpdateJobDetails.
Returns: The result_location of this UpdateJobDetails. Return type: oci.database_management.models.JobExecutionResultLocation
-
role
¶ Gets the role of this UpdateSqlJobDetails. The role of the database user. Indicates whether the database user is a normal user or sysdba.
Returns: The role of this UpdateSqlJobDetails. Return type: str
-
schedule_details
¶ Gets the schedule_details of this UpdateJobDetails.
Returns: The schedule_details of this UpdateJobDetails. Return type: oci.database_management.models.JobScheduleDetails
-
secret_id
¶ Gets the secret_id of this UpdateSqlJobDetails. The OCID of the secret containing the user password.
Returns: The secret_id of this UpdateSqlJobDetails. Return type: str
-
sql_text
¶ Gets the sql_text of this UpdateSqlJobDetails. The SQL text to be executed as part of the job.
Returns: The sql_text of this UpdateSqlJobDetails. Return type: str
-
sql_type
¶ Gets the sql_type of this UpdateSqlJobDetails.
Returns: The sql_type of this UpdateSqlJobDetails. Return type: str
-
timeout
¶ Gets the timeout of this UpdateJobDetails. The job timeout duration, which is expressed like “1h 10m 15s”.
Returns: The timeout of this UpdateJobDetails. Return type: str
-
user_name
¶ Gets the user_name of this UpdateSqlJobDetails. The database user name used to execute the SQL job. If the job is being executed on a Managed Database Group, then the user name should exist on all the databases in the group with the same password.
Returns: The user_name of this UpdateSqlJobDetails. Return type: str
-