Schedule Azure Stored Procedure Execution


i have azure sql database contains stored procedure. need execute stored procedure @ top of every hour. how 'schedule' occur? 

within azure, looks can't 'scheduler'. 

i have searched , searched resources on this, started go 'runbooks' route, , cannot figure out.

thank help.

1) please create powershell (ps) script execute stored procedure (sp), test ps script local machine.

2) please follow first runbook document, create new runbook ps script step#1. test once , make sure sp getting executed azure automation.

3) click on schedule icon in runbook , schedule it. relevant document

thanks. had created runbook , thing missing how integrate ps script it. needed 'edit' runbook in order this. going 'automation scripts', , that's not needed.


Microsoft Azure  >  Azure Automation



Comments

Popular posts from this blog

BizTalk Server 2013 Azure VM Log Shipping and HA for hosts

SQL Server 2008 - High Memory Usage

How to send non-standard Content-Type header ?