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?
x6yk4ghg1#
You're using Azure SQL DB. It does not support SQL Agent.
You'll need to look at using Windows Task Scheduler or a commercial product to provide scheduling services.
9lowa7mx2#
To use SSIS with Azure SQL Database, you need to use Azure Data Factory.
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.
2条答案
按热度按时间x6yk4ghg1#
You're using Azure SQL DB. It does not support SQL Agent.
You'll need to look at using Windows Task Scheduler or a commercial product to provide scheduling services.
9lowa7mx2#
To use SSIS with Azure SQL Database, you need to use Azure Data Factory.
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.