Package com.oracle.bmc.databasemanagement.model

Class SqlJob.Builder

  • Enclosing class:
    SqlJob
    public static class SqlJob.Builder
extends Object

    • Constructor Detail

      • Builder

        public Builder()

    • Method Detail

      • managedDatabaseGroupId

        public SqlJob.Builder managedDatabaseGroupId​(String managedDatabaseGroupId)

      • submissionErrorMessage

        public SqlJob.Builder submissionErrorMessage​(String submissionErrorMessage)

      • 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

      • 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()