Class UpdateSqlJobDetails

The details specific to the SQL job request.

Inheritance

object

UpdateJobDetails

UpdateSqlJobDetails

Inherited Members

UpdateJobDetails.Description

UpdateJobDetails.Timeout

UpdateJobDetails.ResultLocation

UpdateJobDetails.ScheduleDetails

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.DatabasemanagementService.Models

Assembly: OCI.DotNetSDK.Databasemanagement.dll

Syntax

public class UpdateSqlJobDetails : UpdateJobDetails

Properties

DefinedTags

Declaration

[JsonProperty(PropertyName = "definedTags")]
public Dictionary<string, Dictionary<string, object>> DefinedTags { get; set; }

Property Value

Type	Description
Dictionary<string, Dictionary<string, object>>	Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations": {"CostCenter": "42"}}

FreeformTags

Declaration

[JsonProperty(PropertyName = "freeformTags")]
public Dictionary<string, string> FreeformTags { get; set; }

Property Value

Type	Description
Dictionary<string, string>	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"}

InBinds

Declaration

[JsonProperty(PropertyName = "inBinds")]
public JobInBindsDetails InBinds { get; set; }

Property Value

Type	Description
JobInBindsDetails

NamedCredentialId

Declaration

[JsonProperty(PropertyName = "namedCredentialId")]
public string NamedCredentialId { get; set; }

Property Value

Type	Description
string	The OCID of the Named Credentials containing password secret.

OutBinds

Declaration

[JsonProperty(PropertyName = "outBinds")]
public JobOutBindsDetails OutBinds { get; set; }

Property Value

Type	Description
JobOutBindsDetails

Password

Declaration

[JsonProperty(PropertyName = "password")]
public string Password { get; set; }

Property Value

Type	Description
string	The password for the database user name used to execute the SQL job.

Role

Declaration

[JsonProperty(PropertyName = "role")]
[JsonConverter(typeof(StringEnumConverter))]
public SqlJob.RoleEnum? Role { get; set; }

Property Value

Type	Description
SqlJob.RoleEnum?	The role of the database user. Indicates whether the database user is a normal user or sysdba.

SecretId

Declaration

[JsonProperty(PropertyName = "secretId")]
public string SecretId { get; set; }

Property Value

Type	Description
string	The OCID of the secret containing the user password.

SqlText

Declaration

[JsonProperty(PropertyName = "sqlText")]
public string SqlText { get; set; }

Property Value

Type	Description
string	The SQL text to be executed as part of the job.

SqlType

Declaration

[JsonProperty(PropertyName = "sqlType")]
[JsonConverter(typeof(StringEnumConverter))]
public SqlJob.SqlTypeEnum? SqlType { get; set; }

Property Value

Type	Description
SqlJob.SqlTypeEnum?

UserName

Declaration

[JsonProperty(PropertyName = "userName")]
public string UserName { get; set; }

Property Value

Type	Description
string	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.