SQL Server Agent in Azure SQL Server

Question

Hello, I would like to know if you can help me with a problem I am having.

I have Azure SQL Data Bases which are managed through SQL Management Studio. I need to check some of these Databases to see if they have Jobs configured, but I cannot see the SQL Server Agent node within the SQL Server where the databases are.

I am connected to the databases with the Administrator user with which they were created, so I rule out that it is a permissions issue.

The other problem is that I cannot find either the service or the option to see if the SQL Server Agent is disabled.

How can I do this?

Thanks

Answer 1

Hi @Fernando Gutierrez,

Thanks for the question and using MS Q&A platform.

 In Azure SQL Database, you won't find SQL Server Agent as you would in on-premises SQL Server. Consequently, the SQL Server Agent node is absent in SQL Server Management Studio (SSMS). Azure SQL Database does not support SQL Server Agent jobs, meaning you cannot create or manage jobs in the same way as in a traditional SQL Server environment.

If you have multiple databases and need to manage jobs across them, consider using Azure SQL Elastic Jobs. This service is specifically designed to schedule and manage jobs across Azure SQL Databases.

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.