예제 #1
0
 private ScheduledExecution GetScheduledExecution(DateTime executionDateTime, Job job,
                                                  IList <SystemJobSchedule> systemJobSchedules, List <sysjobhistory> workingDurations)
 {
     if (!workingDurations.Any() ||
         !systemJobSchedules.Any(
             schedule => schedule.JobId == job.JobId && schedule.NextRunDate >= executionDateTime))
     {
         return(new ScheduledExecution(job.JobId, job.Name, executionDateTime));
     }
     else
     {
         var standardDeviation = StandardDeviation(workingDurations, sysjobhistory => sysjobhistory.run_duration);
         if (!standardDeviation.HasValue)
         {
             return(new ScheduledExecution(job.JobId, job.Name,
                                           executionDateTime,
                                           SqlConverter.GetRunDurationFromInt(
                                               (int)workingDurations.Average(sysjobhistory => sysjobhistory.run_duration))));
         }
         return(new ScheduledExecution(job.JobId, job.Name,
                                       executionDateTime,
                                       SqlConverter.GetRunDurationFromInt(
                                           (int)workingDurations.Average(sysjobhistory => sysjobhistory.run_duration)),
                                       SqlConverter.GetRunDurationFromInt(
                                           (int)
                                           standardDeviation
                                           .Value)));
     }
 }
예제 #2
0
        public IList <RunTimeStatistics> GetRunTimeStatistics(IList <Job> jobs, DateTime minDateTime)
        {
            var jobRunDuration       = _jobRepository.GetJobHistory(jobs.Select(job => job.JobId));
            var jobRunTimeStatistics = new List <RunTimeStatistics>();
            var systemJobSchedules   =
                _dataMapper.Map <IList <SystemJobSchedule> >(
                    _jobRepository.GetJobSchedules()
                    .Where(sysjobschedule => sysjobschedule.job_id != null && sysjobschedule.schedule_id != null));

            foreach (var job in jobs)
            {
                var workingDurations = jobRunDuration.Where(sysjobhistory => sysjobhistory.job_id == job.JobId);
                if (!workingDurations.Any() ||
                    !systemJobSchedules.Any(
                        schedule => schedule.JobId == job.JobId && schedule.NextRunDate >= minDateTime))
                {
                    continue;
                }
                var statistics = new RunTimeStatistics
                {
                    JobId           = job.JobId,
                    JobName         = job.Name,
                    AverageDuration =
                        SqlConverter.GetRunDurationFromInt(
                            (int)workingDurations.Average(sysjobhistory => sysjobhistory.run_duration)),
                    MaxDuration =
                        SqlConverter.GetRunDurationFromInt(
                            workingDurations.Max(sysjobhistory => sysjobhistory.run_duration)),
                    NextRunDate = systemJobSchedules.Single(sysschedule => sysschedule.JobId == job.JobId).NextRunDate
                };
                var runDurationStandardDeviation = StandardDeviation(workingDurations,
                                                                     sysjobhistory => sysjobhistory.run_duration);
                if (runDurationStandardDeviation.HasValue)
                {
                    statistics.RunDurationStandardDeviation =
                        SqlConverter.GetRunDurationFromInt((int)runDurationStandardDeviation.Value);
                }

                jobRunTimeStatistics.Add(statistics);
            }

            return(jobRunTimeStatistics);
        }