Posts

Showing posts with the label sql-azure

Use Azure Functions to Execute a SQL Azure Stored Procedure on a Timer

Image
It was hard to find this information all in one place, so I thought I'd throw a post together quick.

If you have the need to execute a stored procedure on a timer, that can be fairly easily accomplished with Azure Functions.

Create a new Timer Trigger Azure Function, set the cron timer as desired, and add code similar to the code below:

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using Dapper;

public static void Run(TimerInfo myTimer, TraceWriter log)
{
    var conString = ConfigurationManager.ConnectionStrings["ConString"]?.ConnectionString;

    using(var con = new SqlConnection(conString))
    {
        con.Execute("dbo.MyProc", commandType: CommandType.StoredProcedure);
    }
}


This code will not compile at this time. Note the name of the connection string, we'll need that in the app settings page.

Go to the Connection Strings section of the Application Settings for the function app (this will look very similar to the Con…