public async Task <IReadOnlyList <JobHistoryEntryDto> > SelectJobHistoryEntries(string schedulerName)
{
var sql = AdoJobStoreUtil.ReplaceTablePrefix(SqlSelectHistoryEntry, tablePrefix, null);
List <JobHistoryEntryDto> entries = new List <JobHistoryEntryDto>();
using (var dbConnection = GetConnection(IsolationLevel.ReadUncommitted))
{
using (var dbCommand = Delegate.PrepareCommand(dbConnection, sql))
{
Delegate.AddCommandParameter(dbCommand, "schedulerName", schedulerName);
using (var reader = await dbCommand.ExecuteReaderAsync().ConfigureAwait(false))
{
while (await reader.ReadAsync().ConfigureAwait(false))
{
JobHistoryEntryDto entry = new JobHistoryEntryDto
{
JobName = reader.GetString("JOB_NAME"),
JobGroup = reader.GetString("JOB_GROUP"),
TriggerName = reader.GetString("TRIGGER_NAME"),
TriggerGroup = reader.GetString("TRIGGER_GROUP"),
FiredTime = Delegate.GetDateTimeFromDbValue(reader["FIRED_TIME"]).GetValueOrDefault(),
ScheduledTime = Delegate.GetDateTimeFromDbValue(reader["SCHED_TIME"]).GetValueOrDefault(),
RunTime = Delegate.GetTimeSpanFromDbValue(reader["RUN_TIME"]).GetValueOrDefault(),
Error = Delegate.GetBooleanFromDbValue(reader["ERROR"]),
ErrorMessage = reader.GetString("ERROR_MESSAGE")
};
entries.Add(entry);
}
}
}
}
return(entries);
}
public async Task<IReadOnlyList<JobHistoryEntryDto>> SelectJobHistoryEntries(string schedulerName)
{
var sql = AdoJobStoreUtil.ReplaceTablePrefix(SqlSelectHistoryEntry, tablePrefix, null);
List<JobHistoryEntryDto> entries = new List<JobHistoryEntryDto>();
using (var dbConnection = GetConnection(IsolationLevel.ReadUncommitted))
{
using (var dbCommand = Delegate.PrepareCommand(dbConnection, sql))
{
Delegate.AddCommandParameter(dbCommand, "schedulerName", schedulerName);
using (var reader = await dbCommand.ExecuteReaderAsync().ConfigureAwait(false))
{
while (await reader.ReadAsync().ConfigureAwait(false))
{
JobHistoryEntryDto entry = new JobHistoryEntryDto
{
JobName = reader.GetString("JOB_NAME"),
JobGroup = reader.GetString("JOB_GROUP"),
TriggerName = reader.GetString("TRIGGER_NAME"),
TriggerGroup = reader.GetString("TRIGGER_GROUP"),
FiredTime = Delegate.GetDateTimeFromDbValue(reader["FIRED_TIME"]).GetValueOrDefault(),
ScheduledTime = Delegate.GetDateTimeFromDbValue(reader["SCHED_TIME"]).GetValueOrDefault(),
RunTime = Delegate.GetTimeSpanFromDbValue(reader["RUN_TIME"]).GetValueOrDefault(),
Error = Delegate.GetBooleanFromDbValue(reader["ERROR"]),
ErrorMessage = reader.GetString("ERROR_MESSAGE")
};
entries.Add(entry);
}
}
}
}
return entries;
}