sql-serverazure-sql-databasessms

No SQL Server Agent in Azure SQL?


SQL Server Agent is missing from my SSMS. I have attached the screen shot for your reference. Please let me know if anybody knows the reason?

Image of SSMS


Solution

  • To use SSIS with Azure SQL Database, you need to use Azure Data Factory.

    enter image description here

    You use the SSIS catalog to store your SSIS projects, and Azure Data Factory to schedule them. You can also schedule them with Azure SQL Database Elastic Jobs.