Class JobExecution

The details of a job execution.

Inheritance

object

JobExecution

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.DatabasemanagementService.Models

Assembly: OCI.DotNetSDK.Databasemanagement.dll

Syntax

public class JobExecution

Properties

CompartmentId

Declaration

[Required(ErrorMessage = "CompartmentId is required.")]
[JsonProperty(PropertyName = "compartmentId")]
public string CompartmentId { get; set; }

Property Value

Type	Description
string	The OCID of the compartment in which the parent job resides.

Remarks

Required

DatabaseSubType

Declaration

[JsonProperty(PropertyName = "databaseSubType")]
[JsonConverter(typeof(ResponseEnumConverter))]
public DatabaseSubType? DatabaseSubType { get; set; }

Property Value

Type	Description
DatabaseSubType?	The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, or a Non-container Database.

DatabaseType

Declaration

[JsonProperty(PropertyName = "databaseType")]
[JsonConverter(typeof(ResponseEnumConverter))]
public DatabaseType? DatabaseType { get; set; }

Property Value

Type	Description
DatabaseType?	The type of Oracle Database installation.

DeploymentType

Declaration

[JsonProperty(PropertyName = "deploymentType")]
[JsonConverter(typeof(ResponseEnumConverter))]
public DeploymentType? DeploymentType { get; set; }

Property Value

Type	Description
DeploymentType?	A list of the supported infrastructure that can be used to deploy the database.

ErrorMessage

Declaration

[JsonProperty(PropertyName = "errorMessage")]
public string ErrorMessage { get; set; }

Property Value

Type	Description
string	The error message that is returned if the job execution fails. Null is returned if the job is still running or if the job execution is successful.

Id

Declaration

[Required(ErrorMessage = "Id is required.")]
[JsonProperty(PropertyName = "id")]
public string Id { get; set; }

Property Value

Type	Description
string	The identifier of the job execution.

Remarks

Required

InBinds

Declaration

[JsonProperty(PropertyName = "inBinds")]
public JobInBindsDetails InBinds { get; set; }

Property Value

Type	Description
JobInBindsDetails

IsCluster

Declaration

[JsonProperty(PropertyName = "isCluster")]
public bool? IsCluster { get; set; }

Property Value

Type	Description
bool?	Indicates whether the Oracle Database is part of a cluster.

JobId

Declaration

[Required(ErrorMessage = "JobId is required.")]
[JsonProperty(PropertyName = "jobId")]
public string JobId { get; set; }

Property Value

Type	Description
string	The OCID of the parent job.

Remarks

Required

JobName

Declaration

[Required(ErrorMessage = "JobName is required.")]
[JsonProperty(PropertyName = "jobName")]
public string JobName { get; set; }

Property Value

Type	Description
string	The name of the parent job.

Remarks

Required

JobRunId

Declaration

[Required(ErrorMessage = "JobRunId is required.")]
[JsonProperty(PropertyName = "jobRunId")]
public string JobRunId { get; set; }

Property Value

Type	Description
string	The identifier of the associated job run.

Remarks

Required

ManagedDatabaseGroupId

Declaration

[JsonProperty(PropertyName = "managedDatabaseGroupId")]
public string ManagedDatabaseGroupId { get; set; }

Property Value

Type	Description
string	The OCID of the Managed Database Group where the parent job has to be executed.

ManagedDatabaseId

Declaration

[Required(ErrorMessage = "ManagedDatabaseId is required.")]
[JsonProperty(PropertyName = "managedDatabaseId")]
public string ManagedDatabaseId { get; set; }

Property Value

Type	Description
string	The OCID of the Managed Database associated with the job execution.

Remarks

Required

ManagedDatabaseName

Declaration

[Required(ErrorMessage = "ManagedDatabaseName is required.")]
[JsonProperty(PropertyName = "managedDatabaseName")]
public string ManagedDatabaseName { get; set; }

Property Value

Type	Description
string	The name of the Managed Database associated with the job execution.

Remarks

Required

Name

Declaration

[Required(ErrorMessage = "Name is required.")]
[JsonProperty(PropertyName = "name")]
public string Name { get; set; }

Property Value

Type	Description
string	The name of the job execution.

Remarks

Required

OutBinds

Declaration

[JsonProperty(PropertyName = "outBinds")]
public JobOutBindsDetails OutBinds { get; set; }

Property Value

Type	Description
JobOutBindsDetails

ResultDetails

Declaration

[JsonProperty(PropertyName = "resultDetails")]
public JobExecutionResultDetails ResultDetails { get; set; }

Property Value

Type	Description
JobExecutionResultDetails

ScheduleDetails

Declaration

[JsonProperty(PropertyName = "scheduleDetails")]
public JobScheduleDetails ScheduleDetails { get; set; }

Property Value

Type	Description
JobScheduleDetails

SqlText

Declaration

[JsonProperty(PropertyName = "sqlText")]
public string SqlText { get; set; }

Property Value

Type	Description
string	The SQL text executed as part of the job.

Status

Declaration

[Required(ErrorMessage = "Status is required.")]
[JsonProperty(PropertyName = "status")]
[JsonConverter(typeof(ResponseEnumConverter))]
public JobExecution.StatusEnum? Status { get; set; }

Property Value

Type	Description
JobExecution.StatusEnum?	The status of the job execution.

Remarks

Required

TimeCompleted

Declaration

[JsonProperty(PropertyName = "timeCompleted")]
public DateTime? TimeCompleted { get; set; }

Property Value

Type	Description
DateTime?	The date and time when the job execution completed.

TimeCreated

Declaration

[Required(ErrorMessage = "TimeCreated is required.")]
[JsonProperty(PropertyName = "timeCreated")]
public DateTime? TimeCreated { get; set; }

Property Value

Type	Description
DateTime?	The date and time when the job execution was created.

Remarks

Required

UserName

Declaration

[JsonProperty(PropertyName = "userName")]
public string UserName { get; set; }

Property Value

Type	Description
string	The database user name used to execute the SQL job.

WorkloadType

Declaration

[JsonProperty(PropertyName = "workloadType")]
[JsonConverter(typeof(ResponseEnumConverter))]
public WorkloadType? WorkloadType { get; set; }

Property Value

Type	Description
WorkloadType?	The workload type of the Autonomous Database.