private static void UpdateDatabaseWithSnapShot(Data.ApplicationDataSet.JSJobStepsRow dataRow, string snapShotError)
{
try
{
dataRow.SnapShotDate = DateTime.Now;
dataRow.SnapShotError = snapShotError;
Common.ApplicationDataSet.JSJobStepsTA.Update(Common.ApplicationDataSet.JSJobSteps);
}
catch (Exception ex)
{
string errorMessage = string.Format("JSJobStepsRow.ID:{0} - ex:{1} ex.Inner:{2}", dataRow.ID, ex, ex.InnerException);
VNC.AppLog.Error(errorMessage, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 7);
}
}
public static void UpdateDataSet(this MSMOA.JobStep jobStep, Data.ApplicationDataSet.JSJobStepsRow dataRow)
{
try
{
dataRow.DatabaseName = jobStep.DatabaseName;
dataRow.DatabaseUserName = jobStep.DatabaseUserName;
dataRow.LastRunDate = jobStep.LastRunDate;
dataRow.LastRunDuration = jobStep.LastRunDuration;
dataRow.LastRunOutcome = jobStep.LastRunOutcome.ToString();
dataRow.LastRunRetries = jobStep.LastRunRetries;
dataRow.ProxyName = jobStep.ProxyName;
dataRow.Server = jobStep.Server;
}
catch (Exception ex)
{
VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 7);
// TODO(crhodes):
// Wrap anything above that throws an exception that we want to ignore,
// e.g. property not available because of SQL Edition.
}
}
