Results 1 to 3 of 3

Thread: [RESOLVED] How do I schedule a query in Azure Db?

  1. Oct 21st, 2019, 05:15 PM #1
    cory_jackson
    cory_jackson is offline

    Thread Starter
    Frenzied Member cory_jackson's Avatar
    Join Date
    Dec 2011
    Location
    Fallbrook, California
    Posts
    1,104

    Resolved [RESOLVED] How do I schedule a query in Azure Db?

    I have an Azure SQL Server Db, not one running on a VM, and I would like to schedule a simple SQL Query to run periodically to delete rows from a table based on age. I can make the query, but how does one schedule queries to run in and Azure SQL Server Db?
    Reply With Quote Reply With Quote
  2. Oct 21st, 2019, 05:37 PM #2
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,347

    Re: How do I schedule a query in Azure Db?

    As far as I'm aware, you don't do it IN the database. For a regular SQL Server instance you would use SQL Server Agent but there is no such thing in Azure. For scheduled tasks in Azure, you can create a WebJob if you already have an App Service and you can create an Azure Function otherwise. The latter is a beefed up version of the former, or maybe it's more correct to say that the former is a stripped down version of the latter.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW) | C# (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW)
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
  3. Oct 22nd, 2019, 06:51 PM #3
    cory_jackson
    cory_jackson is offline

    Thread Starter
    Frenzied Member cory_jackson's Avatar
    Join Date
    Dec 2011
    Location
    Fallbrook, California
    Posts
    1,104

    Re: How do I schedule a query in Azure Db?

    Thanks a million John. You saved me time looking for something i don't have. I don't want to learn about WebJob and the App service yet so I think I'll just make an app on my desktop computer and schedule it. YOu rock. Thanks again.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width