How can I run an automation template

Question

Oyin 20

I want to run an automation template for a sql database deployed with ARM. The aim is to trigger a stored procedure

0 comments

Answer accepted by question author

Abiola Akinbade 30,505 Volunteer Moderator

Hello,

Thanks for your question.

To do this I will recommend using a managed identity with the appropriate resource contributor permissions on least privilege scope

You can get the access token using:
$Token = (Get-AZAccessToken -ResourceUrl https://database.windows.net).Token

you can then use Invoke-Sqlcmd to execute the stored procedure requirement

See an example here to execute stored procedure.

Invoke-Sqlcmd -ServerInstance $Server -Database $db -AccessToken $token `

         -Query "exec [dbo].[procedure] @Operation='all', @LogToTable=1" `

         -QueryTimeout 65535 -ConnectionTimeout 60 -Verbose

Also consider setting appropriate schedules and variables for your automation account depending on your use case.

Please let me know if you have further questions

You can mark it 'Accept Answer' if this helped.

0 comments

1 additional answer

Answer 1

Ruel G. Cabusas 225

Have you tried/ considered using Logic Apps?

0 comments