Exceeded maximum execution time on Google App script

Question

The 2 jobs run fine independently, however when I run them both under 1 job (MONTHLY_BUDGET), i get the following error: "Exceeded maximum execution time".

How can i exceed the execution time for the following:

function MONTHLY_BUDGET(){

  BudgetMetric_ActivityDays();
  BudgetMetric_GrossRevenue();

  }


function Weekly_BudgetMetric_ActivityDays(){ 

  var sheetName = "Weekly Budget (Blended)";
  var sql = ' SQL ';
   var ranges = ["wkmbddate","wkmbd1","wkmbd2","wkmbd3","wkmbd4","wkmbd5","wkmbd6","wkmbd7","wkmbd8","wkmbd9","wkmbd10"];
   GSReport.runQueryAndInputData(sheetName, sql, ranges, 0);
}


function Weekly_BudgetMetric_GrossRevenue(){ 

  var sheetName = "Weekly Budget (Blended)";
  var sql = ' SQL ';
   var ranges = ["wkbmgdate","wkbmg1","wkbmg2","wkbmg3","wkbmg4","wkbmg5","wkbmg6","wkbmg7","wkbmg8","wkbmg9","wkbmg10"];
   GSReport.runQueryAndInputData(sheetName, sql, ranges, 0);
}

Felipe Hoffa Felipe Hoffa · Accepted Answer · 2014-02-11T19:04:47

Check this answer on how to add a time trigger. That way you can submit the queries in one execution, and check for their results on a different one:

Google app script timeout ~ 5 minutes?

Exceeded maximum execution time on Google App script

1 Answers