UpdateSqlJobDetails

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

Bases: UpdateJobDetails

The details specific to the SQL job request.

Attributes:

JOB_TYPE_SQL

A constant which can be used with the job_type property of a UpdateJobDetails.

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'

A constant which can be used with the job_type property of a UpdateJobDetails. This constant has a value of “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.

property 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))

property description

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

Returns

The description of this UpdateJobDetails.

Return type

str

property 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.

property in_binds

Gets the in_binds of this UpdateSqlJobDetails.

Returns

The in_binds of this UpdateSqlJobDetails.

Return type

oci.database_management.models.JobInBindsDetails

property 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

property 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

property out_binds

Gets the out_binds of this UpdateSqlJobDetails.

Returns

The out_binds of this UpdateSqlJobDetails.

Return type

oci.database_management.models.JobOutBindsDetails

property 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

property result_location

Gets the result_location of this UpdateJobDetails.

Returns

The result_location of this UpdateJobDetails.

Return type

oci.database_management.models.JobExecutionResultLocation

property 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

property schedule_details

Gets the schedule_details of this UpdateJobDetails.

Returns

The schedule_details of this UpdateJobDetails.

Return type

oci.database_management.models.JobScheduleDetails

property 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

property 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

property sql_type

Gets the sql_type of this UpdateSqlJobDetails.

Returns

The sql_type of this UpdateSqlJobDetails.

Return type

str

property 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

property 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