public void Setup() { _schedulerService = new DefaultJobSchedulerService(); _schedulerService.UnitOfWork = new UnitOfWork(); ISchedulerFactory sf = new StdSchedulerFactory(); ((DefaultJobSchedulerService)_schedulerService).Scheduler = sf.GetScheduler(); _schedulerService.Start(); _sqlJobTrigger = new SqlJobTrigger { CreatedBy = "Pepe", CreatedDate = DateTime.Now, Enabled = true, JobLogs = new List<JobLog>(), JobTriggerStatus = JobTriggerStatus.NoAgendado, XmlFormInputValues = "<prueba>Prueba</prueba>", }; _sqlJob = new SqlJob { Comments = "blabla", CreatedBy = "sdsd", DatabaseName = "CGControlPanel3", CreatedDate = DateTime.Now, Deleted = false, DeletedBy = string.Empty, Description = "Descripcion", IsFavorite = true, ExecutionDays = 1, Group = "Replicación", Name = "Job Replicación 1", JobType = JobType.Automatico, InputSchemaProcedure = "wdwdsadsa", JOB_GROUP = "wwww", JOB_NAME = "adasas", JobStatus = JobStatus.Scheduled, JobStatusEnum = 1, JobTypeEnum = 1, Password = "******", Logs = new List<JobLog>(), Triggers = new List<JobTrigger> { _sqlJobTrigger }, SCHED_NAME = "asdsdsa", LastExecutionStatus = LastExecutionStatus.Success, LastExecutionStatusEnum = 1, ServerName = @".\SQLEXPRESS", UserName = "******", ExecProcedure = "OP_PROCESO_EJEMPLO_EXEC", }; _sqlJobTrigger.Job = _sqlJob; }
public void Setup() { stream = new FileStream(@"C:\test.xlsx", FileMode.Open, FileAccess.Read, FileShare.ReadWrite); IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream); excelReader.IsFirstRowAsColumnNames = true; DataSet result = excelReader.AsDataSet(); ISchedulerFactory sf = new StdSchedulerFactory(); if (_schedulerService == null) { _schedulerService = new DefaultJobSchedulerService(); ((DefaultJobSchedulerService)_schedulerService).Scheduler = sf.GetScheduler(); } _unitOfWork = new UnitOfWork(); _schedulerService.UnitOfWork = _unitOfWork; //_schedulerService.Resume(); _sqlJobTrigger = new SqlJobTrigger { CreatedBy = "Pepe", CreatedDate = DateTime.Now, Enabled = true, JobTriggerStatus = JobTriggerStatus.NoAgendado, InputFormXmlValues = "<prueba>Prueba</prueba>", ScheduledStartExecutionDate = DateTime.Now }; _sqlJob = new SqlJob { Comments = "blabla", CreatedBy = "sdsd", DatabaseName = "cgQuartz", CreatedDate = DateTime.Now, Deleted = false, DeletedBy = string.Empty, Description = "Descripcion", IsFavorite = true, Group = "Replicación", Name = "Job Replicación 1", JobType = JobType.Automático, InputSchemaProcedure = "wdwdsadsa", JobTypeEnum = 1, Password = "******", ServerName = @".\SQLEXPRESS", UserName = "******", ExecProcedure = "OP_PROCESO_QUARTZ_EXEC", }; _sqlJobTrigger2 = new SqlJobTrigger { CreatedBy = "Pepe", CreatedDate = DateTime.Now, Enabled = true, JobTriggerStatus = JobTriggerStatus.NoAgendado, InputFormXmlValues = "<prueba>Prueba2</prueba>", ScheduledStartExecutionDate = DateTime.Now }; _sqlJobTrigger3 = new SqlJobTrigger { CreatedBy = "Pepe", CreatedDate = DateTime.Now, Enabled = true, JobTriggerStatus = JobTriggerStatus.NoAgendado, InputFormXmlValues = "<prueba>Prueba2</prueba>", ScheduledStartExecutionDate = DateTime.Now }; _sqlJobTrigger4 = new SqlJobTrigger { CreatedBy = "Pepe", CreatedDate = DateTime.Now, Enabled = true, JobTriggerStatus = JobTriggerStatus.NoAgendado, InputFormXmlValues = "<prueba>Prueba2</prueba>", ScheduledStartExecutionDate = DateTime.Now }; _sqlJobTrigger5 = new SqlJobTrigger { CreatedBy = "Pepe", CreatedDate = DateTime.Now, Enabled = true, JobTriggerStatus = JobTriggerStatus.NoAgendado, InputFormXmlValues = "<prueba>Prueba2</prueba>", ScheduledStartExecutionDate = DateTime.Now }; _sqlJobTrigger6 = new SqlJobTrigger { CreatedBy = "Pepe", CreatedDate = DateTime.Now, Enabled = true, JobTriggerStatus = JobTriggerStatus.NoAgendado, InputFormXmlValues = "<prueba>Prueba2</prueba>", ScheduledStartExecutionDate = DateTime.Now }; _sqlJob2 = new SqlJob { Comments = "blabla2", CreatedBy = "sdsd2", DatabaseName = "cgQuartz", CreatedDate = DateTime.Now, Deleted = false, DeletedBy = string.Empty, Description = "Descripcion", IsFavorite = true, Group = "Replicación", Name = "Job Replicación 2", JobType = JobType.Automático, InputSchemaProcedure = "wdwdsadsa2", JobTypeEnum = 1, Password = "******", ServerName = @".\SQLEXPRESS", UserName = "******", ExecProcedure = "OP_PROCESO_QUARTZ_EXEC2", }; _sqlJob3 = new SqlJob { Comments = "blabla3", CreatedBy = "sdsd3", DatabaseName = "cgQuartz", CreatedDate = DateTime.Now, Deleted = false, DeletedBy = string.Empty, Description = "Descripcion", IsFavorite = true, Group = "Replicación", Name = "Job Replicación 3", JobType = JobType.Automático, InputSchemaProcedure = "wdwdsadsa3", JobTypeEnum = 1, Password = "******", ServerName = @".\SQLEXPRESS", UserName = "******", ExecProcedure = "OP_PROCESO_QUARTZ_EXEC3", }; _sqlJob4 = new SqlJob { Comments = "blabla4", CreatedBy = "sdsd4", DatabaseName = "cgQuartz", CreatedDate = DateTime.Now, Deleted = false, DeletedBy = string.Empty, Description = "Descripcion", IsFavorite = true, Group = "Replicación", Name = "Job Replicación 4", JobType = JobType.Automático, InputSchemaProcedure = "wdwdsadsa4", JobTypeEnum = 1, Password = "******", ServerName = @".\SQLEXPRESS", UserName = "******", ExecProcedure = "OP_PROCESO_QUARTZ_EXEC4", }; _sqlJob4 = new SqlJob { Comments = "blabla5", CreatedBy = "sdsd5", DatabaseName = "cgQuartz", CreatedDate = DateTime.Now, Deleted = false, DeletedBy = string.Empty, Description = "Descripcion", IsFavorite = true, Group = "Replicación", Name = "Job Replicación 5", JobType = JobType.Automático, InputSchemaProcedure = "wdwdsadsa5", JobTypeEnum = 1, Password = "******", ServerName = @".\SQLEXPRESS", UserName = "******", ExecProcedure = "OP_PROCESO_QUARTZ_EXEC5", }; _sqlJob5 = new SqlJob { Comments = "blabla6", CreatedBy = "sdsd6", DatabaseName = "cgQuartz", CreatedDate = DateTime.Now, Deleted = false, DeletedBy = string.Empty, Description = "Descripcion", IsFavorite = true, Group = "Replicación", Name = "Job Replicación 6", JobType = JobType.Automático, InputSchemaProcedure = "wdwdsadsa6", JobTypeEnum = 1, Password = "******", ServerName = @".\SQLEXPRESS", UserName = "******", ExecProcedure = "OP_PROCESO_QUARTZ_EXEC6", }; }
public void GetJobs_Mehtod_Should_Return_A_Job_List() { var schedulerService = new DefaultJobSchedulerService(); var jobs = schedulerService.GetJobs(); Assert.IsTrue(jobs.Count > 0); }