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?
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?