Class SqlJob

The details of the SQL job.

Inheritance

object

Job

SqlJob

Inherited Members

Job.Id

Job.CompartmentId

Job.Name

Job.Description

Job.ManagedDatabaseGroupId

Job.ManagedDatabaseId

Job.ManagedDatabasesDetails

Job.DatabaseSubType

Job.ScheduleType

Job.LifecycleState

Job.Timeout

Job.ResultLocation

Job.ScheduleDetails

Job.SubmissionErrorMessage

Job.TimeCreated

Job.TimeUpdated

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 SqlJob : Job

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(ResponseEnumConverter))]
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

Role

Declaration

[JsonProperty(PropertyName = "role")]
[JsonConverter(typeof(ResponseEnumConverter))]
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.

SqlText

Declaration

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

Property Value

Type	Description
string	The SQL text to be executed in the job. This is a mandatory field for the EXECUTE_SQL operationType.

SqlType

Declaration

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

Property Value

Type	Description
SqlJob.SqlTypeEnum?	The type of SQL. This is a mandatory field for the EXECUTE_SQL operationType.

SystemTags

Declaration

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

Property Value

Type	Description
Dictionary<string, Dictionary<string, object>>	System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. System tags can be viewed by users, but can only be created by the system. Example: {"orcl-cloud": {"free-tier-retained": "true"}}

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.