Automation and Scheduling in Azure SQL Database

[@mamul1968]

Thanks David - Very good presentation.

[@bmonkeynoob5925]

Your skills and knowledge are amazing. Wish the the small dots were readable. Wish I could copy some of the scripts, hard to search on gethynellis for a nooby like myself :) Keep up this good stuff! ^_^

[@ImmiTheKhan]

Awesome and very precise! Thanks a ton for the clear explanation.

[@markwhite168]

Nice video. I wonder my MSFT decided not to have Agent in SQL DB.

[@helmundschneider4920]

Hi David, i have created a procedure in sql server that refresh the information of a table , i want to schedule that procedure in my azure server which is installed in another computer to run it in the morning lets say at 5 am , my computer will be off but the server will be online, is it possible for azure server to execute that procedure? perhaps through a powershell script or something?

[@nirupam3579]

Sir have u come up with a solution for this, I also need a way to refresh information without the pc being turned on,would be really helpful if u had a solution with you

[@MIPunter]

@David :I created same runbook for one test table. When I ran it it just says Completed nut not giving any output. Plz help me?

[@studyeasygallery7286]

I want schedule job those frequency of repation is select through table value. Ex: i scheduled one job with repetaion of 5 min. And i have table "abc" and in that table one column value is 10 so from next execution it should repeat at 10 min

[@ImmiTheKhan]

Keep up the good work, please some videos on AI usage as well. Subscribed!

[@MagivaIT]

Could you add the code you used here in the thread ?

[@DavidPostlethwaiteSQL]

Example code can be found in my ebook which you can download for free from gethynellis.com