public async static Task Run([TimerTrigger("0 0 4-23 * * *")] TimerInfo myTimer, ILogger log) { log.LogInformation($"C# Timer trigger function executed at: {DateTime.Now}"); string str = Environment.GetEnvironmentVariable("sqldb_connectionstring"); using SqlConnection conn = new SqlConnection(str); conn.Open(); List <LegoSet> updatedSets = DbUtils.GetSetsWithEmailToSend(conn); List <Subscription> subscriptions = DbUtils.GetActiveSubscriptions(conn); Dictionary <(int number, bool isBigUpdate), MailMessage> messages = MessageCreator.GetMessagesForUpdatedSets(updatedSets); await EmailSender.SendEmails(subscriptions, messages); DbUtils.UpdateSetsAfterSendingEmails(conn, updatedSets); }