public IEnumerable<JobInstance> FindJobInstances(Guid userGuid, Guid queueInstanceGuid, HashSet<Guid> jobDefinitionGuids, JobExecutionState jobExecutionStatus)
{
string sql = "spFindJobInstance_byDetails";
using (SqlCommand cmd = Context.CreateStoredProcedureCommand(sql))
{
cmd.Parameters.Add("@UserGuid", SqlDbType.UniqueIdentifier).Value = Context.UserGuid;
cmd.Parameters.Add("@ShowHidden", SqlDbType.Bit).Value = Context.ShowHidden;
cmd.Parameters.Add("@ShowDeleted", SqlDbType.Bit).Value = Context.ShowDeleted;
cmd.Parameters.Add("@From", SqlDbType.Int).Value = DBNull.Value;
cmd.Parameters.Add("@Max", SqlDbType.Int).Value = DBNull.Value;
cmd.Parameters.Add("@RowCount", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@JobUserGuid", SqlDbType.UniqueIdentifier).Value = userGuid == Guid.Empty ? DBNull.Value : (object)userGuid;
cmd.Parameters.Add("@QueueInstanceGuid", SqlDbType.UniqueIdentifier).Value = queueInstanceGuid == Guid.Empty ? DBNull.Value : (object)queueInstanceGuid;
cmd.Parameters.Add("@JobDefinitionGuids", SqlDbType.Structured).Value = CreateGuidListTable(jobDefinitionGuids);
cmd.Parameters.Add("@JobExecutionStatus", SqlDbType.Int).Value = jobExecutionStatus;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
JobInstance item = new JobInstance(Context);
item.LoadFromDataReader(dr);
yield return item;
}
dr.Close();
}
}
}
private void InitializeMembers()
{
this.userGuid = Guid.Empty;
this.queueInstanceGuid = Guid.Empty;
this.jobDefinitionGuids = new HashSet <Guid>();
this.jobExecutionStatus = JobExecutionState.All;
}
public ReportJobState(Guid jobId, string jobType, JobExecutionState result, string error, DateTime startTime, DateTime?endTime, JobDetails details = null)
{
JobId = jobId;
JobType = jobType;
Result = result;
Error = error;
StartTime = startTime;
EndTime = endTime;
Details = details;
}
/// <summary>
/// Creates a deep copy of the passed object.
/// </summary>
/// <param name="old">A <b>Database Definition</b> object to create the deep copy from.</param>
private void CopyMembers(JobInstance old)
{
this.workflowTypeName = old.workflowTypeName;
this.dateStarted = old.dateStarted;
this.dateFinished = old.dateFinished;
this.jobExecutionStatus = old.jobExecutionStatus;
this.suspendTimeout = old.suspendTimeout;
this.scheduleType = old.scheduleType;
this.scheduleTime = old.scheduleTime;
this.recurringPeriod = old.recurringPeriod;
this.recurringInterval = old.recurringInterval;
this.recurringMask = old.recurringMask;
this.workflowInstanceId = old.workflowInstanceId;
this.adminRequestTime = old.adminRequestTime;
this.adminRequestData = old.adminRequestData == null ? null : new JobAdminRequestData(old.adminRequestData);
this.adminRequestResult = old.adminRequestResult;
this.exceptionMessage = old.exceptionMessage;
this.parameters = new ParameterCollection(old.parameters);
}
private void InitializeMembers(StreamingContext context)
{
this.workflowTypeName = string.Empty;
this.dateStarted = DateTime.MinValue;
this.dateFinished = DateTime.MinValue;
this.jobExecutionStatus = JobExecutionState.Unknown;
this.suspendTimeout = DateTime.MinValue;
this.scheduleType = ScheduleType.Unknown;
this.scheduleTime = DateTime.MinValue;
this.recurringPeriod = RecurringPeriod.Unknown;
this.recurringInterval = 0;
this.recurringMask = 0;
this.workflowInstanceId = Guid.Empty;
this.adminRequestTime = DateTime.MinValue;
this.adminRequestData = null;
this.adminRequestResult = -1;
this.exceptionMessage = null;
this.parameters = new ParameterCollection();
}
private void InitializeMembers()
{
this.status = JobExecutionState.Unknown;
}
/// <summary>
/// Initializes member variables to their initial values.
/// </summary>
/// <remarks>
/// This function is called by the contructors.
/// </remarks>
private void InitializeMembers()
{
base.EntityType = EntityType.JobInstance;
base.EntityGroup = EntityGroup.Jobs;
this.workflowTypeName = string.Empty;
this.dateStarted = DateTime.MinValue;
this.dateFinished = DateTime.MinValue;
this.jobExecutionStatus = JobExecutionState.Unknown;
this.suspendTimeout = DateTime.MinValue;
this.scheduleType = ScheduleType.Unknown;
this.scheduleTime = DateTime.MinValue;
this.recurringPeriod = RecurringPeriod.Unknown;
this.recurringInterval = 0;
this.recurringMask = 0;
this.workflowInstanceId = Guid.Empty;
this.adminRequestTime = DateTime.MinValue;
this.adminRequestData = null;
this.adminRequestResult = -1;
this.exceptionMessage = null;
this.parameters = new Dictionary<string, JobParameter>();
this.checkpoints = new List<JobCheckpoint>();
}
/// <summary>
/// Creates a deep copy of the passed object.
/// </summary>
/// <param name="old">A <b>Database Definition</b> object to create the deep copy from.</param>
private void CopyMembers(JobInstance old)
{
this.workflowTypeName = old.workflowTypeName;
this.dateStarted = old.dateStarted;
this.dateFinished = old.dateFinished;
this.jobExecutionStatus = old.jobExecutionStatus;
this.suspendTimeout = old.suspendTimeout;
this.scheduleType = old.scheduleType;
this.scheduleTime = old.scheduleTime;
this.recurringPeriod = old.recurringPeriod;
this.recurringInterval = old.recurringInterval;
this.recurringMask = old.recurringMask;
this.workflowInstanceId = old.workflowInstanceId;
this.adminRequestTime = old.adminRequestTime;
this.adminRequestData = old.adminRequestData == null ? null : new JobAdminRequestData(old.adminRequestData);
this.adminRequestResult = old.adminRequestResult;
this.exceptionMessage = old.exceptionMessage;
// TODO: do deep copy here?
this.parameters = new Dictionary<string, JobParameter>(old.parameters);
this.checkpoints = new List<JobCheckpoint>(old.checkpoints);
}
/// <summary>
/// Sets a single job instance checkpoint's identified by its name.
/// </summary>
/// <param name="name">Name of the checkpoint.</param>
/// <param name="executionStatus">Execution status of the checkpoint.</param>
/// <remarks>
/// This function is called by the <b>Jhu.Graywulf.Workflow.Activities.CheckpointActivity</b>
/// to record the sequential provenance information of the executing job.
/// </remarks>
public void SetCheckpoint(string name, JobExecutionState executionStatus)
{
string sql = "spSetJobInstanceCheckpoint";
using (SqlCommand cmd = Context.CreateStoredProcedureCommand(sql))
{
cmd.Parameters.Add("@UserGuid", SqlDbType.UniqueIdentifier).Value = Context.UserGuid;
cmd.Parameters.Add("@JobInstanceGuid", SqlDbType.UniqueIdentifier).Value = Guid;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 128).Value = name;
cmd.Parameters.Add("@ExecutionStatus", SqlDbType.Int).Value = executionStatus;
cmd.ExecuteNonQuery();
}
// Write log entry
Jhu.Graywulf.Logging.Event e = new Jhu.Graywulf.Logging.Event("Jhu.Graywulf.Registry.JobInstance.SetCheckpoint", this.Guid);
e.UserData.Add("Name", name);
e.UserData.Add("ExecutionStatus", executionStatus.ToString());
Context.LogEvent(e);
}
/// <summary>
/// Initializes private members to their default values.
/// </summary>
private void InitializeMembers()
{
this.sequenceNumber = -1;
this.name = string.Empty;
this.executionStatus = JobExecutionState.Unknown;
}
private void InitializeMembers()
{
this.status = JobExecutionState.Unknown;
}
public IEnumerable <JobInstance> FindJobInstances(Guid userGuid, Guid queueInstanceGuid, HashSet <Guid> jobDefinitionGuids, JobExecutionState jobExecutionStatus)
{
string sql = "spFindJobInstance_byDetails";
using (SqlCommand cmd = Context.CreateStoredProcedureCommand(sql))
{
cmd.Parameters.Add("@UserGuid", SqlDbType.UniqueIdentifier).Value = Context.UserGuid;
cmd.Parameters.Add("@ShowHidden", SqlDbType.Bit).Value = Context.ShowHidden;
cmd.Parameters.Add("@ShowDeleted", SqlDbType.Bit).Value = Context.ShowDeleted;
cmd.Parameters.Add("@From", SqlDbType.Int).Value = DBNull.Value;
cmd.Parameters.Add("@Max", SqlDbType.Int).Value = DBNull.Value;
cmd.Parameters.Add("@RowCount", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@JobUserGuid", SqlDbType.UniqueIdentifier).Value = userGuid == Guid.Empty ? DBNull.Value : (object)userGuid;
cmd.Parameters.Add("@QueueInstanceGuid", SqlDbType.UniqueIdentifier).Value = queueInstanceGuid == Guid.Empty ? DBNull.Value : (object)queueInstanceGuid;
cmd.Parameters.Add("@JobDefinitionGuids", SqlDbType.Structured).Value = CreateGuidListTable(jobDefinitionGuids);
cmd.Parameters.Add("@JobExecutionStatus", SqlDbType.Int).Value = jobExecutionStatus;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
JobInstance item = new JobInstance(Context);
item.LoadFromDataReader(dr);
yield return(item);
}
dr.Close();
}
}
}
private void InitializeMembers()
{
this.userGuid = Guid.Empty;
this.queueInstanceGuid = Guid.Empty;
this.jobDefinitionGuids = new HashSet<Guid>();
this.jobExecutionStatus = Registry.JobExecutionState.All;
}
