0

I know how to create a JOB in SQL Server via SQL Server Agent. But but but, I'm very new to MS Azure and I have deployed my SQL database on MS Azure.

Here I want to create a job which can run a stored procedure automatically on a specific time of the day, via SQL Server Agent. I searched a lot and came to know that "SQL Server Agent is not an available feature in MS Azure". I find a help link but it was really difficult to get a viable solution.

Can someone share a simple solution so I can get rid on this issue!!

Arsman Ahmad
  • 2,000
  • 1
  • 26
  • 34
  • 1
    You can use this feature: https://azure.microsoft.com/en-us/services/scheduler/ - SQL Job Agent on MS Azure has been disabled by MS - Also see this post https://stackoverflow.com/questions/27309474/best-way-to-schedule-sql-job-in-microsoft-azure – SqlKindaGuy Jun 29 '18 at 08:01
  • Yes, I solved it with *Scheduler* :-) – Arsman Ahmad Sep 27 '18 at 07:16

1 Answers1

1

Azure doesn't provide SQL Server Agent job feature. But it has a very dynamic and vast feature i.e. Scheduler. Scheduler schedules almost everything whatever you want to trigger on Azure. Whether it is DB object, App Services etc.

So, you can use Scheduler on azure to do your work done. For more details go to this link.

Scheduler Services

Prateek Sharma
  • 132
  • 4