How To Schedule Stored Procedure in Azure SQL Database | Azure Automation Account

preview_player
Показать описание


*** Advance your career or learn some new skills with one of these courses ***

Azure SQL database does not have a SQL Agent service component which can be used to create and schedule jobs. The Agent is still available on SQL Server on-premises and is often used to schedule the running of stored procedures and other objects.
Рекомендации по теме
Комментарии
Автор

Thank you! This not only solved my issue but saved me $$ doing something I was trying to do in a Data Factory.

zb
Автор

You legend. Finally managed to get this working 💪 thank you for posting

robertgunkel
Автор

This is exactly what I needed, Thanks

marcinolejarz
Автор

Its helped for me...Thankyou for explanation and script also.

premenderrayabarapu
Автор

Nicely done! You have a very relaxed way of teaching us. I have a question - if I had a need to run two stored procedures sequentially, would you recommend a dedicated workbook per stored proc, or can I set up where one workbooks can run two stored procedures sequentially? (I don't want to create a 'driver' sproc that runs each stored proc from there either). Ok thank you very much for this video and the script!

RJ-lfex
Автор

Love it as always, do you have any websites or good videos to just practice using sql ? Or free practice exams? Im looking for anything to constantly have my mind on Sql and mastering this skill.

QueenNSim
Автор

Where did you write store procedures in onprem sql.or azure sql ? Can we use this method to sync data between two dbs ? I have other team onprem sql db, I want to consume some tables from others team db to my team azure sql db

mohammedali-mjth