public void AddToQueueLog(JobInstance jobInstance)
{
if (jobInstance == null)
{
throw new Exception("Job instance can not be null.");
}
using (var dbContext = new ls.QueueManagementDataContext(_connectionString))
{
var now = DateTime.Now;
var queuedJobInstance = new ls.JobQueue();
queuedJobInstance.JobInstanceId = jobInstance.Id;
queuedJobInstance.QueueRequestId = jobInstance.QueueRequest.Id;
queuedJobInstance.JobId = jobInstance.Job.Id;
queuedJobInstance.CreatedDate = now;
queuedJobInstance.UpdatedDate = now;
queuedJobInstance.SourceDataSourceId = jobInstance.SourceDataSource.DataSource.Id;
queuedJobInstance.TargetDataSourceId = jobInstance.TargetDataSource.DataSource.Id;
queuedJobInstance.Filters = JobFilterHelper.GetTextForDatabase(jobInstance.Filters);
queuedJobInstance.InvocationSource = jobInstance.InvocationSource;
queuedJobInstance.ScheduledStartTime = jobInstance.ScheduledStartTime;
queuedJobInstance.ActualStartTime = jobInstance.ActualStartTime.HasValue ? jobInstance.ActualStartTime.Value : new DateTime?();
queuedJobInstance.IsOnDemand = jobInstance.InvocationSourceType == JobInvocationSourceType.OnDemand ? true : false;
queuedJobInstance.JobQueueStatusId = (byte)jobInstance.Status;
dbContext.JobQueues.InsertOnSubmit(queuedJobInstance);
dbContext.SubmitChanges();
foreach (var jobStepInstance in jobInstance.JobStepInstances)
{
var queuedJobStepInstance = new ls.JobStepQueue();
queuedJobStepInstance.JobStepInstanceId = jobStepInstance.Id;
queuedJobStepInstance.JobInstanceId = jobInstance.Id;
queuedJobStepInstance.JobStepId = jobStepInstance.JobStep.Id;
queuedJobStepInstance.CreatedDate = now;
queuedJobStepInstance.UpdatedDate = now;
queuedJobStepInstance.ActualStartTime = jobStepInstance.ActualStartTime.HasValue ? jobStepInstance.ActualStartTime.Value : new DateTime?();
queuedJobStepInstance.ActualEndTime = jobStepInstance.ActualEndTime.HasValue ? jobStepInstance.ActualEndTime.Value : new DateTime?();
queuedJobStepInstance.OrderIndex = (byte)jobStepInstance.OrderIndex;
queuedJobStepInstance.JobStepQueueStatusId = (byte)jobStepInstance.Status;
dbContext.JobStepQueues.InsertOnSubmit(queuedJobStepInstance);
}
dbContext.SubmitChanges();
}
}
public void DeleteFromQueueLog(Guid jobInstanceId)
{
using (var dbContext = new ls.QueueManagementDataContext(_connectionString))
{
var queuedJobStepInstances = dbContext.JobStepQueues.Where(d => d.JobInstanceId == jobInstanceId).ToList();
dbContext.JobStepQueues.DeleteAllOnSubmit(queuedJobStepInstances);
dbContext.SubmitChanges();
var queuedJobInstances = dbContext.JobQueues.Where(d => d.JobInstanceId == jobInstanceId).ToList();
dbContext.JobQueues.DeleteAllOnSubmit(queuedJobInstances);
dbContext.SubmitChanges();
}
}
public void UpdateJobStatusInQueueLog(JobInstance jobInstance)
{
if (jobInstance == null)
{
throw new Exception("Job instance can not be null.");
}
using (var dbContext = new ls.QueueManagementDataContext(_connectionString))
{
var queuedJobInstance = dbContext.JobQueues.Where(d => d.JobInstanceId == jobInstance.Id).FirstOrDefault();
if (queuedJobInstance != null)
{
queuedJobInstance.UpdatedDate = DateTime.Now;
queuedJobInstance.ActualStartTime = jobInstance.ActualStartTime.HasValue ? jobInstance.ActualStartTime.Value : new DateTime?();
queuedJobInstance.JobQueueStatusId = (byte)jobInstance.Status;
dbContext.SubmitChanges();
}
}
}
public void MoveToHistoryLog(JobInstance jobInstance)
{
if (jobInstance == null)
{
throw new Exception("Job instance can not be null.");
}
using (var dbContext = new ls.QueueManagementDataContext(_connectionString))
{
var now = DateTime.Now;
var jobHistory = new ls.JobHistory();
jobHistory.JobInstanceId = jobInstance.Id;
jobHistory.QueueRequestId = jobInstance.QueueRequest.Id;
jobHistory.JobId = jobInstance.Job.Id;
jobHistory.CreatedDate = now;
jobHistory.UpdatedDate = now;
jobHistory.SourceDataSourceId = jobInstance.SourceDataSource.DataSource.Id;
jobHistory.TargetDataSourceId = jobInstance.TargetDataSource.DataSource.Id;
jobHistory.Filters = JobFilterHelper.GetTextForDatabase(jobInstance.Filters);
jobHistory.InvocationSource = jobInstance.InvocationSource;
jobHistory.ScheduledStartTime = jobInstance.ScheduledStartTime;
jobHistory.ActualStartTime = jobInstance.ActualStartTime.HasValue ? jobInstance.ActualStartTime.Value : new DateTime?();
if (jobInstance.TimeToStartDelay.HasValue && jobInstance.TimeToStartDelay.Value.Hours > 23)
{
jobHistory.TimeToStartDelay = new TimeSpan(23, 59, 59);
}
else if (jobInstance.TimeToStartDelay.HasValue)
{
jobHistory.TimeToStartDelay = jobInstance.TimeToStartDelay.Value;
}
else
{
jobHistory.TimeToStartDelay = new TimeSpan(0, 0, 0);
}
jobHistory.ActualEndTime = jobInstance.ActualEndTime.HasValue ? jobInstance.ActualEndTime.Value : new DateTime?();
if (jobInstance.ActualDuration.HasValue && jobInstance.ActualDuration.Value.Hours > 23)
{
jobHistory.ActualDuration = new TimeSpan(23, 59, 59);
}
else if (jobInstance.ActualDuration.HasValue)
{
jobHistory.ActualDuration = jobInstance.ActualDuration.Value;
}
else
{
jobHistory.ActualDuration = new TimeSpan(0, 0, 0);
}
jobHistory.IsOnDemand = jobInstance.InvocationSourceType == JobInvocationSourceType.OnDemand ? true : false;
jobHistory.JobQueueStatusId = (byte)jobInstance.Status;
jobHistory.HasRecordErrors = jobInstance.HasRecordErrors;
jobHistory.HasRuntimeErrors = jobInstance.HasRuntimeErrors;
dbContext.JobHistories.InsertOnSubmit(jobHistory);
dbContext.SubmitChanges();
foreach (var jobStepInstance in jobInstance.JobStepInstances)
{
var jobStepHistory = new ls.JobStepHistory();
jobStepHistory.JobHistoryId = jobHistory.JobHistoryId;
jobStepHistory.JobStepInstanceId = jobStepInstance.Id;
jobStepHistory.JobInstanceId = jobInstance.Id;
jobStepHistory.JobStepId = jobStepInstance.JobStep.Id;
jobStepHistory.CreatedDate = now;
jobStepHistory.UpdatedDate = now;
jobStepHistory.ActualStartTime = jobStepInstance.ActualStartTime.HasValue ? jobStepInstance.ActualStartTime.Value : new DateTime?();
jobStepHistory.ActualEndTime = jobStepInstance.ActualEndTime.HasValue ? jobStepInstance.ActualEndTime.Value : new DateTime?();
if (jobStepInstance.ActualDuration.HasValue && jobStepInstance.ActualDuration.Value.Hours > 23)
{
jobStepHistory.ActualDuration = new TimeSpan(23, 59, 59);
}
else if (jobStepInstance.ActualDuration.HasValue)
{
jobStepHistory.ActualDuration = jobStepInstance.ActualDuration.Value;
}
else
{
jobStepHistory.ActualDuration = new TimeSpan(0, 0, 0);
}
jobStepHistory.OrderIndex = (byte)jobStepInstance.OrderIndex;
jobStepHistory.JobStepQueueStatusId = (byte)jobStepInstance.Status;
jobStepHistory.HasRecordErrors = jobStepInstance.HasRecordErrors;
jobStepHistory.HasRuntimeErrors = jobStepInstance.HasRuntimeErrors;
dbContext.JobStepHistories.InsertOnSubmit(jobStepHistory);
}
dbContext.SubmitChanges();
DeleteFromQueueLog(jobInstance.Id);
}
}