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.

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): 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.

Share Runbook in Azure SQLDB

Accepted answer

Anurag Sharma 17,591 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):

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.
Please sign in to rate this answer.
Vijay Kumar 2,031 Reputation points

2020-10-21T07:27:56.29+00:00

This looking good anurag.

But i am looking for the maintenance plan run in different schedules.
Like,

DB1 on Every Monday @ 10 PM
DB2 on Every Tuesday @ 10 PM
DB3 on Every Wednesday @ 10 PM
DB4 on Every Thursday @ 10 PM

Anurag Sharma 17,591 Reputation points

2020-10-21T08:15:54.47+00:00

Hi @Vijay Kumar , thanks for reverting back.

If you are looking for different schedule for different databases, suggested approach would be creating separate runbooks and scheduling them as per the requirements of the databases. This would also help in case you want to remove any database from the schedule, you could just unplug that runbook with no effects on others. Also if somethings goes wrong with one, there is no impact on others.

Vijay Kumar 2,031 Reputation points

2020-10-21T08:48:01.537+00:00

Thank you Anurag.

One more question

Using Runbook or Elastic Jobs--> which option is cost ($$$) effective? i mean less cost.

Anurag Sharma 17,591 Reputation points

2020-10-21T09:13:31.017+00:00

Hi @Vijay Kumar , for automation account runbooks, pricing is very straight forward (based on job run time) as mentioned in the link:

However 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)

Please let me know if that helps.

----------

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

Share via

Share Runbook in Azure SQLDB

0 additional answers