January 27, 2020 at 1:40 pm
I triad to open an Azure database in SSMS and it opens fine, I can see data and query tables but I'm missing SQL Server Agent with which to run nightly jobs. Is there another tool I should be using to open this?
January 27, 2020 at 2:35 pm
Azure SQL Database doesn't come with an agent. As such you need to use an elastic job instead to schedule these.
If you need the traditional SQL Agent, you will need to look at managed instances or VM's with full blown SQL on them.
January 28, 2020 at 1:39 pm
There are many different scheduling services within Azure. Find one of them and put it to work.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply