Class CreateSqlJobDetails

The details specific to the SQL job request.

Inheritance

object

CreateJobDetails

CreateSqlJobDetails

Inherited Members

CreateJobDetails.Name

CreateJobDetails.Description

CreateJobDetails.CompartmentId

CreateJobDetails.ManagedDatabaseGroupId

CreateJobDetails.ManagedDatabaseId

CreateJobDetails.DatabaseSubType

CreateJobDetails.ScheduleType

CreateJobDetails.Timeout

CreateJobDetails.ResultLocation

CreateJobDetails.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 CreateSqlJobDetails : CreateJobDetails

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.

OperationType

Declaration

[Required(ErrorMessage = "OperationType is required.")]
[JsonProperty(PropertyName = "operationType")]
[JsonConverter(typeof(StringEnumConverter))]
public SqlJob.OperationTypeEnum? OperationType { get; set; }

Property Value

Type	Description
SqlJob.OperationTypeEnum?	The SQL operation type.

Remarks

Required

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.