Share Runbook in Azure SQLDB

Vijay Kumar 2,011 Reputation points
2020-10-20T22:52:22.077+00:00

Hi,

I am planning to implement maintenance plan on 5 Azure SQL DB.

So can i use same or share existing rubook for all DB's?

if not i will create separate runbook for all 5 Azure SQL DB's.

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Anurag Sharma 17,536 Reputation points
    2020-10-21T06:49:18.223+00:00

    Hi @Vijay Kumar , welcome to Microsoft Q&A forum.

    To answer your query, yes you can have shared runbook for different azure SQL databases and execute it like below(just a simple example and there are many ways to write the code):

    33840-image.png

    However, these queries run one after the other in sequence. So please think through if you want to run them together or in sequence.

    ----------

    If answer helps, please select 'Accept Answer' as it could help other community members looking for similar queries.


0 additional answers

Sort by: Most helpful