Execute an SQL stored procedure with an Azure Webjob
<p>I followed the steps on <a href="https://azure.microsoft.com/en-us/documentation/articles/web-sites-create-web-jobs/" rel="nofollow">this page</a> to create a webjob that is scheduled to run every five minutes. The purpose of the webjob is to execute an SQL stored procedure. The problem is that I can't find any script to make the webjob execute the stored procedure.</p>

<p>On the other hand, with the Scheduler of Azure mobile aps, the <a href="http://blogs.msdn.com/b/ms-tech_learning_with_prasant/archive/2014/07/09/scheduling-job-on-sql-azure.aspx" rel="nofollow">following script</a> will execute the stored procedure:</p>

<pre><code>function Execute_updateNames() {
     mssql.query('Exec dbo.updateNames',{
     success: function(results){
     console.log("Successful...");
     },
      error: function(err) {
        console.log("Error is: " + err);
     }
 });
</code></pre>

<p>} </p>

<p>My question is how can I execute a stored procedure with an Azure Webjob. A script sample is well appreciated.</p>