private static void Update(MSMOA.JobSchedule jobSchedule, SQLInformation.Data.ApplicationDataSet.JSJobSchedulesRow dataRow)
{
try
{
jobSchedule.UpdateDataSet(dataRow);
UpdateDatabaseWithSnapShot(dataRow, "");
}
catch (Exception ex)
{
VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 6);
UpdateDatabaseWithSnapShot(dataRow, ex.ToString().Substring(0, 256));
}
}
private static SQLInformation.Data.ApplicationDataSet.JSJobSchedulesRow Add(MSMOA.JobSchedule jobSchedule)
{
SQLInformation.Data.ApplicationDataSet.JSJobSchedulesRow dataRow = null;
try
{
dataRow = Common.ApplicationDataSet.JSJobSchedules.NewJSJobSchedulesRow();
dataRow.ID = Guid.NewGuid();
dataRow.Name_JSJobSchedule = jobSchedule.Name;
//jobScheduleRow.JSJob_ID = jobID;
dataRow.ActiveEndDate = jobSchedule.ActiveEndDate;
dataRow.ActiveEndTimeOfDay = jobSchedule.ActiveEndTimeOfDay;
dataRow.ActiveStartDate = jobSchedule.ActiveStartDate;
dataRow.ActiveStartTimeOfDay = jobSchedule.ActiveStartTimeOfDay;
dataRow.DateCreated = jobSchedule.DateCreated;
dataRow.FrequencyInterval = jobSchedule.FrequencyInterval.ToString();
dataRow.FrequencyRecurrenceFactor = jobSchedule.FrequencyRecurrenceFactor.ToString();
dataRow.FrequencyRelativeIntervals = jobSchedule.FrequencyRelativeIntervals.ToString();
dataRow.FrequencySubDayInterval = jobSchedule.FrequencySubDayInterval.ToString();
dataRow.FrequencySubDayTypes = jobSchedule.FrequencySubDayTypes.ToString();
dataRow.FrequencyTypes = jobSchedule.FrequencyTypes.ToString();
dataRow.ID_JobSchedule = jobSchedule.ID;
dataRow.IsEnabled = jobSchedule.IsEnabled;
dataRow.JobCount = jobSchedule.JobCount;
dataRow.SnapShotDate = DateTime.Now;
dataRow.SnapShotError = "";
Common.ApplicationDataSet.JSJobSchedules.AddJSJobSchedulesRow(dataRow);
Common.ApplicationDataSet.JSJobSchedulesTA.Update(Common.ApplicationDataSet.JSJobSchedules);
}
catch (Exception ex)
{
VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 5);
// TODO(crhodes):
// Wrap anything above that throws an exception that we want to ignore,
// e.g. property not available because of SQL Edition.
UpdateDatabaseWithSnapShot(dataRow, ex.ToString().Substring(0, 256));
}
return(dataRow);
}
private static void Update(MSMOA.JobSchedule jobSchedule, SQLInformation.Data.ApplicationDataSet.JSJobSchedulesRow dataRow)
{
//try
//{
// if (dataRow.IsMonitored)
// {
// jobSchedule.UpdateDataSet(dataRow);
// UpdateDatabaseWithSnapShot(dataRow, "");
// }
//}
//catch (Exception ex)
//{
// UpdateDatabaseWithSnapShot(dataRow, ex.ToString().Substring(0, 256));
// VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 9);
//}
}
private static SQLInformation.Data.ApplicationDataSet.JSJobSchedulesRow GetInfoFromSMO(MSMOA.JobSchedule jobSchedule, SQLInformation.Data.ApplicationDataSet.JobServersRow jobServerRow)
{
#if TRACE
long startTicks = VNC.AppLog.Trace4(string.Format("Enter ({0})", jobSchedule.Name), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2);
#endif
SQLInformation.Data.ApplicationDataSet.JSJobSchedulesRow dataRow = null;
try
{
// TODO(crhodes) Needs work. See TBTrigger for hints
// JSJob_ID may be null.
var jbs = from js in Common.ApplicationDataSet.JSJobSchedules
where js.JSJob_ID == jobServerRow.ID
select js;
var dbs2 = from db2 in jbs
where db2.Name_JSJobSchedule == jobSchedule.Name
select db2;
if (dbs2.Count() > 0)
{
dataRow = dbs2.First();
Update(jobSchedule, dataRow);
}
else
{
dataRow = Add(jobSchedule);
}
}
catch (Exception ex)
{
VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3);
}
#if TRACE
VNC.AppLog.Trace4("Exit", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 4, startTicks);
#endif
return(dataRow);
}
private static SQLInformation.Data.ApplicationDataSet.JSJobSchedulesRow GetInfoFromSMO(MSMOA.JobSchedule jobSchedule, SQLInformation.Data.ApplicationDataSet.JobServersRow jobServerRow)
{
#if TRACE
long startTicks = VNC.AppLog.Trace4(string.Format("Enter ({0})", jobSchedule.Name), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2);
#endif
SQLInformation.Data.ApplicationDataSet.JSJobSchedulesRow dataRow = null;
//// TODO(crhodes) Needs work. See TBTrigger for hints
//var dbs = from db in Common.ApplicationDataSet.JSJobSchedules
// where db. == jobServerRow.ID
// select db;
//var dbs2 = from db2 in dbs
// where db2.Name_JSJobSchedule == jobSchedule.Name
// select db2;
//if (dbs2.Count() > 0)
//{
// // We have found a JobServer with a matching name.
// // TODO(crhodes): There should only be one.
// try
// {
// foreach (var item in dbs2)
// {
// jobScheduleRow = item;
// //if (targetServerRow.IsMonitored)
// //{
// // // Update the main entry
// jobSchedule.UpdateDataSet(item);
// jobScheduleRow.SnapShotDate = DateTime.Now;
// jobScheduleRow.SnapShotError = "";
// Common.ApplicationDataSet.JSJobSchedulesTA.Update(Common.ApplicationDataSet.JSJobSchedules);
// // // Add add the Snapshot
// // //TakeJobServerSnapShot(jobServerRow);
// //}
// }
// }
// catch (Exception ex)
// {
// jobScheduleRow.SnapShotDate = DateTime.Now;
// jobScheduleRow.SnapShotError = ex.ToString().Substring(0, 256);
// Common.ApplicationDataSet.JSJobSchedulesTA.Update(Common.ApplicationDataSet.JSJobSchedules);
// VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 41);
// }
//}
//else
//{
// // Add new one
// try
// {
// jobScheduleRow = Common.ApplicationDataSet.JSJobSchedules.NewJSJobSchedulesRow();
// jobScheduleRow.ID = Guid.NewGuid();
// jobScheduleRow.Name_JSJobSchedule = jobSchedule.Name;
// jobScheduleRow.JSJob_ID = jobID;
// jobScheduleRow.ActiveEndDate = jobSchedule.ActiveEndDate;
// jobScheduleRow.ActiveEndTimeOfDay = jobSchedule.ActiveEndTimeOfDay;
// jobScheduleRow.ActiveStartDate = jobSchedule.ActiveStartDate;
// jobScheduleRow.ActiveStartTimeOfDay = jobSchedule.ActiveStartTimeOfDay;
// jobScheduleRow.DateCreated = jobSchedule.DateCreated;
// jobScheduleRow.FrequencyInterval = jobSchedule.FrequencyInterval.ToString();
// jobScheduleRow.FrequencyRecurrenceFactor = jobSchedule.FrequencyRecurrenceFactor.ToString();
// jobScheduleRow.FrequencyRelativeIntervals = jobSchedule.FrequencyRelativeIntervals.ToString();
// jobScheduleRow.FrequencySubDayInterval = jobSchedule.FrequencySubDayInterval.ToString();
// jobScheduleRow.FrequencySubDayTypes = jobSchedule.FrequencySubDayTypes.ToString();
// jobScheduleRow.FrequencyTypes = jobSchedule.FrequencyTypes.ToString();
// jobScheduleRow.ID_JobSchedule = jobSchedule.ID;
// jobScheduleRow.IsEnabled = jobSchedule.IsEnabled;
// jobScheduleRow.JobCount = jobSchedule.JobCount;
// jobScheduleRow.SnapShotDate = DateTime.Now;
//dataRow.SnapShotError = "";
// Common.ApplicationDataSet.JSJobSchedules.AddJSJobSchedulesRow(jobScheduleRow);
// Common.ApplicationDataSet.JSJobSchedulesTA.Update(Common.ApplicationDataSet.JSJobSchedules);
// }
// catch (Exception ex)
// {
// jobScheduleRow.SnapShotDate = DateTime.Now;
// jobScheduleRow.SnapShotError = ex.ToString().Substring(0, 256);
// Common.ApplicationDataSet.JSJobSchedulesTA.Update(Common.ApplicationDataSet.JSJobSchedules);
// VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 47);
// }
//}
#if TRACE
VNC.AppLog.Trace4("Exit", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 10, startTicks);
#endif
return(dataRow);
}