trigger InsertUpdateScheduledJobAfter on Scheduled_Job__c (after insert, after update) {
 Integer intReturn;
 Integer intMagicNum;
 List<Scheduled_Job__c> sjList = new List<Scheduled_Job__c>();
 Datetime dte;
 
 for (Scheduled_Job__c sj : Trigger.new){
  if (sj.Run_Job__c == true){
   
   //Create Site Log records for 7 business days in the future, if needed
   if (sj.Method_To_Execute__c == 'CreateSiteLogs'){
    intReturn = clsScheduledJobs.CreateSiteLogs(null);
    //This job is run in batches of 1 site invoice (the max that can be processed
    //before hitting the governor limit, sadly), so less than 1 means it's done
    intMagicNum = 1;
   } 
   
   //Send out Job Loss Report
   if (sj.Method_To_Execute__c == 'JobLossReport'){
    intReturn = clsScheduledJobs.JobLossReport(null);
    //Single email limited to 10 at a time
    intMagicNum = 10;
   }
      
   if (sj.Method_To_Execute__c == 'ScheduledJobCleanup'){
    intReturn = clsScheduledJobs.ScheduledJobCleanup();
    //This job always returns 0, shouldn't need to be re-run anytime soon
    intMagicNum = 1;
   }
   
   Scheduled_Job__c new_sj = new Scheduled_Job__c(
    Method_To_Execute__c = sj.Method_To_Execute__c,
    Name = sj.Name,
    Run_Job__c = false,
    Schedule__c = true,
    Time_to_Start__c = sj.Time_to_Start__c);
   
   //If the number returned by the method is less than the Magic Number, 
   //create a Scheduled Job record to run it again tomorrow night 
   if (intReturn < intMagicNum){
    //Tomorrow, 12am
    dte = Datetime.newInstance(System.today().year(), System.today().month(), System.today().day()).addDays(1);
    
    //Add on hour/minutes from Time To Start field
    dte = dte.addhours(Integer.valueOf(sj.Time_to_Start__c.substring(0,2)));
    dte = dte.addminutes(Integer.valueOf(sj.Time_to_Start__c.substring(2,4)));
    
    //Sometimes if there are multiple scheduled jobs around the same time,
    //SF processes them in bulk and the governor limits are hit, so make sure 
    //they're all spaced out at least 15 minutes
    sjList = [Select Next_Run_Datetime__c from Scheduled_Job__c
       where Next_Run_Datetime__c >=: dte and  
       Next_Run_Datetime__c <: dte.addMinutes(30) and  
       Schedule__c = true and Run_Job__c = false
       order by Next_Run_Datetime__c DESC
       LIMIT 1];
    dte = (sjList.size() > 0 — sjList[0].Next_Run_Datetime__c.addMinutes(15) : dte);
    //Reset Scheduled Job record to midnight of tomorrow
    new_sj.Next_Run_Datetime__c = dte;
    
   //Otherwise, there are more records to process, so create a record 
   //to run it again immediately
   } else {
    //Make sure this is offset from other jobs so they don't run in bulk
    sjList = [Select Next_Run_Datetime__c from Scheduled_Job__c
       where Next_Run_Datetime__c >=: System.now().addMinutes(-15) and 
       Next_Run_Datetime__c <: System.now().addMinutes(30) and  
       Schedule__c = true and Run_Job__c = false
       order by Next_Run_Datetime__c DESC
       LIMIT 1];
    new_sj.Next_Run_Datetime__c = (sjList.size() > 0 – sjList[0].Next_Run_Datetime__c.addMinutes(15) : System.now());
    
   }
   
   insert new_sj;
  }
  
 }
}