monitor-table-change-with-sqltabledependency
monitor-table-change-with-sqltabledependency copied to clipboard
Design question - feasible to use in Azure DevOps and PowerShell script?
I have a design question. I'm in Azure DevOps pipeline and I need to run pipeline step using sqlcmd.exe (using cmd or PowerShell) to insert a record into a table in database. I then need to poll a table in pipeline step for changes and then resume Azure Pipeline steps whether table notification is a success or not. Can I take advantage of SQL Table Dependency in this particular use case?