SQL Maintenance Tasks on Azure [Ola Hallengren Scripts] I am trying to implement the SQL maintenance scripts from Ola on my Azure elastic pool databases. I did the steps as provided in this link.

I could create the job, but I always get this error after running the job manually:


Does anybody have some experience with these maintenance tasks on Azure?
As mentioned on that article, you are expected to create Hallengren schema and its related database objects on each database on the pool, instead of using the Master database to create the schema and objects. Steps 1 to 4 on that article tell you how to perform that setup using jobs.

After that the article shows you how to use Hallengren scripts.