After setting up a mobile job with the Azure scheduler service some time ago to run a stored procedure on my Azure SQL database periodically, I encountered issues when it was migrated to the new Azure Portal in April and stopped running successfully.
The stored procedure usually takes about 90 seconds to run, but it seems like the job times out before completing now. I suspect that something related to the connection string may have been fixed previously before the migration.
Below is the complete script being executed:
function runTasks() {
var sql = "exec [dbo].[runTasks]";
console.log("Executing runTasks...");
mssql.query(sql,{
success: function(results){
console.log("Finished the runTasks job.");
},
error: function(err) {
console.log("error is: " + err);
}
});
}
Is there a way to increase the timeout for this call?
(I am unsure where the connection string used for this code is located after the migration to the new portal.)