SqlJob.Builder (Oracle Cloud Infrastructure Java SDK

java.lang.Object
- com.oracle.bmc.databasemanagement.model.SqlJob.Builder

Enclosing class:: SqlJob

public static class SqlJob.Builder
extends Object

Constructor Summary

Constructors
Constructor and Description

Builder()

Constructors
Constructor and Description
`Builder()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`SqlJob`	`build()`
`SqlJob.Builder`	`compartmentId(String compartmentId)`
`SqlJob.Builder`	`copy(SqlJob model)`
`SqlJob.Builder`	`databaseSubType(DatabaseSubType databaseSubType)`
`SqlJob.Builder`	`definedTags(Map<String,Map<String,Object>> definedTags)` Defined tags for this resource.
`SqlJob.Builder`	`description(String description)`
`SqlJob.Builder`	`freeformTags(Map<String,String> freeformTags)` Free-form tags for this resource.
`SqlJob.Builder`	`id(String id)`
`SqlJob.Builder`	`inBinds(JobInBindsDetails inBinds)`
`SqlJob.Builder`	`lifecycleState(Job.LifecycleState lifecycleState)`
`SqlJob.Builder`	`managedDatabaseGroupId(String managedDatabaseGroupId)`
`SqlJob.Builder`	`managedDatabaseId(String managedDatabaseId)`
`SqlJob.Builder`	`managedDatabasesDetails(List<JobDatabase> managedDatabasesDetails)`
`SqlJob.Builder`	`name(String name)`
`SqlJob.Builder`	`namedCredentialId(String namedCredentialId)` The OCID of the Named Credentials containing password secret.
`SqlJob.Builder`	`operationType(SqlJob.OperationType operationType)` The SQL operation type.
`SqlJob.Builder`	`outBinds(JobOutBindsDetails outBinds)`
`SqlJob.Builder`	`resultLocation(JobExecutionResultLocation resultLocation)`
`SqlJob.Builder`	`role(SqlJob.Role role)` The role of the database user.
`SqlJob.Builder`	`scheduleDetails(JobScheduleDetails scheduleDetails)`
`SqlJob.Builder`	`scheduleType(Job.ScheduleType scheduleType)`
`SqlJob.Builder`	`sqlText(String sqlText)` The SQL text to be executed in the job.
`SqlJob.Builder`	`sqlType(SqlJob.SqlType sqlType)` The type of SQL.
`SqlJob.Builder`	`submissionErrorMessage(String submissionErrorMessage)`
`SqlJob.Builder`	`systemTags(Map<String,Map<String,Object>> systemTags)` System tags for this resource.
`SqlJob.Builder`	`timeCreated(Date timeCreated)`
`SqlJob.Builder`	`timeout(String timeout)`
`SqlJob.Builder`	`timeUpdated(Date timeUpdated)`
`SqlJob.Builder`	`userName(String userName)` The database user name used to execute the SQL job.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - Builder
```
public Builder()
```
- Method Detail
  - id
```
public SqlJob.Builder id(String id)
```
  - compartmentId
```
public SqlJob.Builder compartmentId(String compartmentId)
```
  - name
```
public SqlJob.Builder name(String name)
```
  - description
```
public SqlJob.Builder description(String description)
```
  - managedDatabaseGroupId
```
public SqlJob.Builder managedDatabaseGroupId(String managedDatabaseGroupId)
```
  - managedDatabaseId
```
public SqlJob.Builder managedDatabaseId(String managedDatabaseId)
```
  - managedDatabasesDetails
```
public SqlJob.Builder managedDatabasesDetails(List<JobDatabase> managedDatabasesDetails)
```
  - databaseSubType
```
public SqlJob.Builder databaseSubType(DatabaseSubType databaseSubType)
```
  - scheduleType
```
public SqlJob.Builder scheduleType(Job.ScheduleType scheduleType)
```
  - lifecycleState
```
public SqlJob.Builder lifecycleState(Job.LifecycleState lifecycleState)
```
  - timeout
```
public SqlJob.Builder timeout(String timeout)
```
  - resultLocation
```
public SqlJob.Builder resultLocation(JobExecutionResultLocation resultLocation)
```
  - scheduleDetails
```
public SqlJob.Builder scheduleDetails(JobScheduleDetails scheduleDetails)
```
  - submissionErrorMessage
```
public SqlJob.Builder submissionErrorMessage(String submissionErrorMessage)
```
  - timeCreated
```
public SqlJob.Builder timeCreated(Date timeCreated)
```
  - timeUpdated
```
public SqlJob.Builder timeUpdated(Date timeUpdated)
```
  - sqlType
```
public SqlJob.Builder sqlType(SqlJob.SqlType sqlType)
```
    The type of SQL. This is a mandatory field for the EXECUTE_SQL operationType.
    
    Parameters:
    
    sqlType - the value to set
    
    Returns:
    
    this builder
  - sqlText
```
public SqlJob.Builder sqlText(String sqlText)
```
    The SQL text to be executed in the job. This is a mandatory field for the EXECUTE_SQL operationType.
    
    Parameters:
    
    sqlText - the value to set
    
    Returns:
    
    this builder
  - inBinds
```
public SqlJob.Builder inBinds(JobInBindsDetails inBinds)
```
  - outBinds
```
public SqlJob.Builder outBinds(JobOutBindsDetails outBinds)
```
  - operationType
```
public SqlJob.Builder operationType(SqlJob.OperationType operationType)
```
    The SQL operation type.
    
    Parameters:
    
    operationType - the value to set
    
    Returns:
    
    this builder
  - userName
```
public SqlJob.Builder userName(String userName)
```
    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.
    
    Parameters:
    
    userName - the value to set
    
    Returns:
    
    this builder
  - role
```
public SqlJob.Builder role(SqlJob.Role role)
```
    The role of the database user. Indicates whether the database user is a normal user or sysdba.
    
    Parameters:
    
    role - the value to set
    
    Returns:
    
    this builder
  - namedCredentialId
```
public SqlJob.Builder namedCredentialId(String namedCredentialId)
```
    The OCID of the Named Credentials containing password secret.
    
    Parameters:
    
    namedCredentialId - the value to set
    
    Returns:
    
    this builder
  - freeformTags
```
public SqlJob.Builder freeformTags(Map<String,String> freeformTags)
```
    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"}
    
    Parameters:
    
    freeformTags - the value to set
    
    Returns:
    
    this builder
  - definedTags
```
public SqlJob.Builder definedTags(Map<String,Map<String,Object>> definedTags)
```
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations": {"CostCenter": "42"}}
    
    Parameters:
    
    definedTags - the value to set
    
    Returns:
    
    this builder
  - systemTags
```
public SqlJob.Builder systemTags(Map<String,Map<String,Object>> systemTags)
```
    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"}}
    
    Parameters:
    
    systemTags - the value to set
    
    Returns:
    
    this builder
  - build
```
public SqlJob build()
```
  - copy
```
public SqlJob.Builder copy(SqlJob model)
```

Class SqlJob.Builder

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

Builder

Method Detail

id

compartmentId

name

description

managedDatabaseGroupId

managedDatabaseId

managedDatabasesDetails

databaseSubType

scheduleType

lifecycleState

timeout

resultLocation

scheduleDetails

submissionErrorMessage

timeCreated

timeUpdated

sqlType

sqlText

inBinds

outBinds

operationType

userName

role

namedCredentialId

freeformTags

definedTags

systemTags

build

copy