@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
__explicitlySet__
. The hashCode()
and equals(Object)
methods are implemented to take
__explicitlySet__
into account. The constructor, on the other hand, does not set __explicitlySet__
(since the constructor cannot distinguish explicit null
from unset null
).
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.
|
Job.LifecycleState, Job.ScheduleType
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,
SqlJob.OperationType operationType,
String userName,
SqlJob.Role role)
Deprecated.
|
Modifier and Type | Method and Description |
---|---|
static SqlJob.Builder |
builder()
Create a new builder.
|
protected boolean |
canEqual(Object other) |
boolean |
equals(Object o) |
Set<String> |
get__explicitlySet__() |
SqlJob.OperationType |
getOperationType()
The SQL operation type.
|
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.
|
String |
getUserName()
The database user name used to execute the SQL job.
|
int |
hashCode() |
SqlJob.Builder |
toBuilder() |
String |
toString() |
getCompartmentId, getDatabaseSubType, getDescription, getId, getLifecycleState, getManagedDatabaseGroupId, getManagedDatabaseId, getManagedDatabasesDetails, getName, getResultLocation, getScheduleDetails, getScheduleType, getSubmissionErrorMessage, getTimeCreated, getTimeout, getTimeUpdated
@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, SqlJob.OperationType operationType, String userName, SqlJob.Role role)
public static SqlJob.Builder builder()
Create a new builder.
public SqlJob.Builder toBuilder()
public SqlJob.SqlType getSqlType()
The type of SQL. This is a mandatory field for the EXECUTE_SQL operationType.
public String getSqlText()
The SQL text to be executed in the job. This is a mandatory field for the EXECUTE_SQL operationType.
public SqlJob.OperationType getOperationType()
The SQL operation type.
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.
public SqlJob.Role getRole()
The role of the database user. Indicates whether the database user is a normal user or sysdba.
Copyright © 2016–2022. All rights reserved.