PowerShell Execute Procedure on webjobs in WebApps (Azure)

execute_procedure_azure.ps1

Write-Output "JOB START"
# Create connection to Master DB
$MasterDatabaseConnection = New-Object System.Data.SqlClient.SqlConnection
$MasterDatabaseConnection.ConnectionString = "Data Source=_DBNAME_.database.windows.net;Initial Catalog=_DBCATALOG_;Integrated Security=False;User ID=_USERDB_;Password=_PASSDB_;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False"
$MasterDatabaseConnection.Open()

Write-Output "CONNECTION OPEN"

# Create command
$MasterDatabaseCommand = New-Object System.Data.SqlClient.SqlCommand
$MasterDatabaseCommand.Connection = $MasterDatabaseConnection
$MasterDatabaseCommand.CommandText = "_NAME_PROCEDURE_TO_EXECUTE_"

Write-Output "DATABASE COMMAND TEXT ASSIGNED"

# Execute the query
$MasterDatabaseCommand.ExecuteNonQuery()

Write-Output "EXECUTING QUERY"

# Close connection to Master DB
$MasterDatabaseConnection.Close() 

Write-Output "CONNECTION CLOSED"