Package com.oracle.bmc.databasemanagement.model

Class 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).

    • Method Detail

      • builder

        public static SqlJob.Builder builder()
        Create a new builder.

      • 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

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