This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 12%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
How to trigger Azure Synapse Pipeline from on premise SQL Server
Hello @MUDIT KUMAR ,
Just checking in to see if the below answer provided by @Nandan Hegde helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Hey,
Sql server jobs have power shell and you can trigger synapse pipelines via API through power shell task
https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/pipeline/create-pipeline-run
Thank you for the suggestion. I have tried that but when I am running SQL job with PowerShell script but it is showing an error.
Message
Executed as user: NT Service\SQLAgent$SQLSERVER2017. A job step received an error at line 1 in a PowerShell script. The corresponding line is 'POST {https://spendwrkspc.dev.azuresynapse.net}/pipelines/{Main_DWH_Pipeline}/createRun?api-version=2020-12-01'. Correct the script and reschedule the job. The error information returned by PowerShell is: 'The term 'POST' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. '. Process Exit Code -1. The step failed.
Can you ping the code here as it seems some code issue.
@Nandan Hegde I have attached 2 screenshots. Kindly go through it.