public void DeleteJob(string jobId)
        {
            var job = SqlMapper.Entity <Models.ScheduleJobInfo>().Where(x => x.JobId == jobId).FirstOrDefault();

            using (var trans = SqlMapper.BeginTransaction())
            {
                try
                {
                    job.JobState = JobState.Deleted;
                    trans.Entity <Models.ScheduleJobInfo>().Update(job);
                    ScheduleManager.DeleteJob(jobId);
                    trans.Commit();
                }
                catch (Exception ex)
                {
                    trans.Rollback();
                    throw ex;
                }
            }
        }