Tuesday, August 27, 2019

Schedule SQL Jobs in Azure


Hello Guys,


Here I'm providing link from where you will get step by step information in order to schedule SQL job in Azure.

https://www.netwoven.com/2017/12/12/schedule-execution-sql-jobs-azure-automation-service/

Workflow to call Stored procedure e.g.

workflow RB_Daily_Job
{
Write-Output('RB_Daily_Job job starting.')
Write-Output('Job is calling UpdateStatus SP.')
$dataTable = RB_Record_AzureScheduler -sqlServer 'dbtest.database.windows.net' -Database 'dbTest' -SprocName 'UpdateStatus' -Parameters '' -SqlCredentialName 'SQLDBCredential'
Write-Output('('RB_Daily_Job  job executed successfully.')
}

Thanks