Automate Maintenance jobs in Azure SQL Database

Vijay Kumar 2,016 Reputation points
2020-10-20T06:58:05.867+00:00

Hi Team,

I am planning to implement Index maintenance job on 5 Azure SQL Db's

Options:

  1. Using Rubook
  2. Elastic Jobs feature.

My question is ,which option is best for cost ($$$) point of view?

Azure SQL Database
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,108 questions
{count} votes

Accepted answer
  1. SwathiDhanwada-MSFT 17,161 Reputation points
    2020-10-27T06:24:12.143+00:00

    @Vijay Kumar Yes you are correct, it does require job database. As mentioned by my colleague in this Q&A question ,for azure elastic jobs, pricing is a little different as it has elastic job agent as well as a job database. Elastic job agent is free but job database is build based on size and usage like normal database.(Refer link for more details).

    Kindly let us know if you have further queries.

    0 comments No comments

0 additional answers

Sort by: Most helpful