Results 1 to 3 of 3

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

  1. #1

    Thread Starter
    Fanatic Member cory_jackson's Avatar
    Join Date
    Dec 2011
    Location
    Fallbrook, California
    Posts
    993

    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?

  2. #2
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    104,967

    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.

  3. #3

    Thread Starter
    Fanatic Member cory_jackson's Avatar
    Join Date
    Dec 2011
    Location
    Fallbrook, California
    Posts
    993

    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.

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
  •  



Click Here to Expand Forum to Full Width