com.oracle.bmc.databasemanagement.model

Class SqlJob

java.lang.Object

com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

com.oracle.bmc.databasemanagement.model.Job

com.oracle.bmc.databasemanagement.model.SqlJob

@Generated(value="OracleSDKGenerator",
           comments="API Version: 20201101")
public final class SqlJob
extends Job

The details of the SQL job.
Note: Objects should always be created or deserialized using the SqlJob.Builder. This model distinguishes fields that are null because they are unset from fields that are explicitly set to null. This is done in the setter methods of the SqlJob.Builder, which maintain a set of all explicitly set fields called SqlJob.Builder.__explicitlySet__. The hashCode() and equals(Object) methods are implemented to take the explicitly set fields into account. The constructor, on the other hand, does not take the explicitly set fields into account (since the constructor cannot distinguish explicit null from unset null).

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SqlJob.Builder
static class	SqlJob.OperationType The SQL operation type.
static class	SqlJob.Role The role of the database user.
static class	SqlJob.SqlType The type of SQL.

Nested classes/interfaces inherited from class com.oracle.bmc.databasemanagement.model.Job

Job.LifecycleState, Job.ScheduleType

Field Summary

Fields inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

EXPLICITLY_SET_FILTER_NAME, EXPLICITLY_SET_PROPERTY_NAME

Constructor Summary

Constructors

Constructor and Description

SqlJob(String id, String compartmentId, String name, String description, String managedDatabaseGroupId, String managedDatabaseId, List<JobDatabase> managedDatabasesDetails, DatabaseSubType databaseSubType, Job.ScheduleType scheduleType, Job.LifecycleState lifecycleState, String timeout, JobExecutionResultLocation resultLocation, JobScheduleDetails scheduleDetails, String submissionErrorMessage, Date timeCreated, Date timeUpdated, SqlJob.SqlType sqlType, String sqlText, JobInBindsDetails inBinds, JobOutBindsDetails outBinds, SqlJob.OperationType operationType, String userName, SqlJob.Role role, String namedCredentialId, Map<String,String> freeformTags, Map<String,Map<String,Object>> definedTags, Map<String,Map<String,Object>> systemTags) Deprecated.

Method Summary

Modifier and Type	Method and Description
static SqlJob.Builder	builder() Create a new builder.
boolean	equals(Object o)
Map<String,Map<String,Object>>	getDefinedTags() Defined tags for this resource.
Map<String,String>	getFreeformTags() Free-form tags for this resource.
JobInBindsDetails	getInBinds()
String	getNamedCredentialId() The OCID of the Named Credentials containing password secret.
SqlJob.OperationType	getOperationType() The SQL operation type.
JobOutBindsDetails	getOutBinds()
SqlJob.Role	getRole() The role of the database user.
String	getSqlText() The SQL text to be executed in the job.
SqlJob.SqlType	getSqlType() The type of SQL.
Map<String,Map<String,Object>>	getSystemTags() System tags for this resource.
String	getUserName() The database user name used to execute the SQL job.
int	hashCode()
SqlJob.Builder	toBuilder()
String	toString()
String	toString(boolean includeByteArrayContents) Return a string representation of the object.

Methods inherited from class com.oracle.bmc.databasemanagement.model.Job

getCompartmentId, getDatabaseSubType, getDescription, getId, getLifecycleState, getManagedDatabaseGroupId, getManagedDatabaseId, getManagedDatabasesDetails, getName, getResultLocation, getScheduleDetails, getScheduleType, getSubmissionErrorMessage, getTimeCreated, getTimeout, getTimeUpdated

Methods inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

markPropertyAsExplicitlySet, wasPropertyExplicitlySet

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Detail

SqlJob

@Deprecated
public SqlJob(String id,
                          String compartmentId,
                          String name,
                          String description,
                          String managedDatabaseGroupId,
                          String managedDatabaseId,
                          List<JobDatabase> managedDatabasesDetails,
                          DatabaseSubType databaseSubType,
                          Job.ScheduleType scheduleType,
                          Job.LifecycleState lifecycleState,
                          String timeout,
                          JobExecutionResultLocation resultLocation,
                          JobScheduleDetails scheduleDetails,
                          String submissionErrorMessage,
                          Date timeCreated,
                          Date timeUpdated,
                          SqlJob.SqlType sqlType,
                          String sqlText,
                          JobInBindsDetails inBinds,
                          JobOutBindsDetails outBinds,
                          SqlJob.OperationType operationType,
                          String userName,
                          SqlJob.Role role,
                          String namedCredentialId,
                          Map<String,String> freeformTags,
                          Map<String,Map<String,Object>> definedTags,
                          Map<String,Map<String,Object>> systemTags)

Deprecated.

Method Detail

builder

public static SqlJob.Builder builder()

Create a new builder.

toBuilder

public SqlJob.Builder toBuilder()

getSqlType

public SqlJob.SqlType getSqlType()

The type of SQL. This is a mandatory field for the EXECUTE_SQL operationType.

Returns:

the value

getSqlText

public String getSqlText()

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

Returns:

the value

getInBinds

public JobInBindsDetails getInBinds()

getOutBinds

public JobOutBindsDetails getOutBinds()

getOperationType

public SqlJob.OperationType getOperationType()

The SQL operation type.

Returns:

the value

getUserName

public String getUserName()

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 value

getRole

public SqlJob.Role getRole()

The role of the database user. Indicates whether the database user is a normal user or sysdba.

Returns:

the value

getNamedCredentialId

public String getNamedCredentialId()

The OCID of the Named Credentials containing password secret.

Returns:

the value

getFreeformTags

public Map<String,String> getFreeformTags()

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 value

getDefinedTags

public Map<String,Map<String,Object>> getDefinedTags()

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 value

getSystemTags

public Map<String,Map<String,Object>> getSystemTags()

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"}}

Returns:

the value

toString

public String toString()

Overrides:

toString in class Job

toString

public String toString(boolean includeByteArrayContents)

Return a string representation of the object.

Overrides:

toString in class Job

Parameters:

includeByteArrayContents - true to include the full contents of byte arrays

Returns:

string representation

equals

public boolean equals(Object o)

Overrides:

equals in class Job

hashCode

public int hashCode()

Overrides:

hashCode in class Job