SqlPlanBaselineJob

class oci.database_management.models.SqlPlanBaselineJob(**kwargs)

Bases: object

The details of the database job used for loading and evolving SQL plan baselines.

Attributes:

STATUS_FAILED

A constant which can be used with the status property of a SqlPlanBaselineJob.

STATUS_SCHEDULED

A constant which can be used with the status property of a SqlPlanBaselineJob.

STATUS_SUCCEEDED

A constant which can be used with the status property of a SqlPlanBaselineJob.

TYPE_LOAD

A constant which can be used with the type property of a SqlPlanBaselineJob.

name

[Required] Gets the name of this SqlPlanBaselineJob.

status

[Required] Gets the status of this SqlPlanBaselineJob.

time_created

Gets the time_created of this SqlPlanBaselineJob.

type

[Required] Gets the type of this SqlPlanBaselineJob.

Methods:

__init__(**kwargs)

Initializes a new SqlPlanBaselineJob object with values from keyword arguments.

STATUS_FAILED = 'FAILED'

A constant which can be used with the status property of a SqlPlanBaselineJob. This constant has a value of “FAILED”

STATUS_SCHEDULED = 'SCHEDULED'

A constant which can be used with the status property of a SqlPlanBaselineJob. This constant has a value of “SCHEDULED”

STATUS_SUCCEEDED = 'SUCCEEDED'

A constant which can be used with the status property of a SqlPlanBaselineJob. This constant has a value of “SUCCEEDED”

TYPE_LOAD = 'LOAD'

A constant which can be used with the type property of a SqlPlanBaselineJob. This constant has a value of “LOAD”

__init__(**kwargs)

Initializes a new SqlPlanBaselineJob object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters
  • name (str) – The value to assign to the name property of this SqlPlanBaselineJob.

  • type (str) – The value to assign to the type property of this SqlPlanBaselineJob. Allowed values for this property are: “LOAD”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

  • status (str) – The value to assign to the status property of this SqlPlanBaselineJob. Allowed values for this property are: “SUCCEEDED”, “SCHEDULED”, “FAILED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

  • time_created (datetime) – The value to assign to the time_created property of this SqlPlanBaselineJob.

property name

[Required] Gets the name of this SqlPlanBaselineJob. The job name.

Returns

The name of this SqlPlanBaselineJob.

Return type

str

property status

[Required] Gets the status of this SqlPlanBaselineJob. The job status.

Allowed values for this property are: “SUCCEEDED”, “SCHEDULED”, “FAILED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The status of this SqlPlanBaselineJob.

Return type

str

property time_created

Gets the time_created of this SqlPlanBaselineJob. The date and time the job was created.

Returns

The time_created of this SqlPlanBaselineJob.

Return type

datetime

property type

[Required] Gets the type of this SqlPlanBaselineJob. The job type.

Allowed values for this property are: “LOAD”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The type of this SqlPlanBaselineJob.

Return type

str