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
`defined_tags`	Gets the defined_tags of this UpdateSqlJobDetails.
`description`	Gets the description of this UpdateJobDetails.
`freeform_tags`	Gets the freeform_tags of this UpdateSqlJobDetails.
`in_binds`	Gets the in_binds of this UpdateSqlJobDetails.
`job_type`	Gets the job_type of this UpdateJobDetails.
`named_credential_id`	Gets the named_credential_id of this UpdateSqlJobDetails.
`out_binds`	Gets the out_binds of this UpdateSqlJobDetails.
`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 is SQL 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.
in_binds (oci.database_management.models.JobInBindsDetails) – The value to assign to the in_binds property of this UpdateSqlJobDetails.
out_binds (oci.database_management.models.JobOutBindsDetails) – The value to assign to the out_binds 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.
named_credential_id (str) – The value to assign to the named_credential_id property of this UpdateSqlJobDetails.
role (str) – The value to assign to the role property of this UpdateSqlJobDetails.
freeform_tags (dict(str, str)) – The value to assign to the freeform_tags property of this UpdateSqlJobDetails.
defined_tags (dict(str, dict(str, object))) – The value to assign to the defined_tags property of this UpdateSqlJobDetails.

defined_tags¶

Gets the defined_tags of this UpdateSqlJobDetails. Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {“Operations”: {“CostCenter”: “42”}}

Returns:	The defined_tags of this UpdateSqlJobDetails.
Return type:	dict(str, dict(str, object))

description¶

Gets the description of this UpdateJobDetails. The description of the job.

Returns:	The description of this UpdateJobDetails.
Return type:	str

freeform_tags¶

Gets the freeform_tags of this UpdateSqlJobDetails. 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”}

Returns:	The freeform_tags of this UpdateSqlJobDetails.
Return type:	dict(str, 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.

in_binds¶

Gets the in_binds of this UpdateSqlJobDetails.

Returns:	The in_binds of this UpdateSqlJobDetails.
Return type:	oci.database_management.models.JobInBindsDetails

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

named_credential_id¶

Gets the named_credential_id of this UpdateSqlJobDetails. The OCID of the Named Credentials containing password secret.

Returns:	The named_credential_id of this UpdateSqlJobDetails.
Return type:	str

out_binds¶

Gets the out_binds of this UpdateSqlJobDetails.

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

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