0

I'm a new PowerBI developer. I am inserting data from the Azure SQL database via SSMS. I don't have access to a server agent for being able to create jobs. I just want to run 4-5 queries (1 query = 1 step for my job). Is there a simple way to do this automatically for example?

Pawel Veselov
  • 3,996
  • 7
  • 44
  • 62
mas
  • 3
  • 1
  • for example, if i can run a .sql file with all my query-code inside automatically; where can i save that file etc – mas Jun 11 '21 at 10:13

1 Answers1

0

Well, there's no server agent in Azure SQL DB, so you cannot create jobs as you do in on-prem or on Azure VM installations.

However, you do have Elastic jobs on Azure which can run queries on Azure SQL Database periodically.

See the documentation here.

PankajSanwal
  • 956
  • 7
  • 14