i want my current pipeline stuck in queue when previous pipeline failed. i don’t want it will be done through script i want any other way. simply i want that when next schedule run the pipeline ,the pipeline stuck in queue because the previous run failed due to any other reason.

azure-pipelines.yml
pool: Default

schedules:

• cron: “*/3 * * * *”
  displayName: Every 10 minutes trigger
  branches:
  include:
  – main

variables:

• group: dbbackup

parameters:

• name: selectedDatabase
  type: string
  default: testdb
  values:
  • testdb
  • testdb1
  • testdb2

stages:

• template: template.yml
  parameters:
  selectedDatabase: ${{ parameters.selectedDatabase }}

template.yml
parameters:
selectedDatabase: ”

stages:

• stage: Backup
  jobs:
  • job: BackupDatabase
    steps:

    • script: |
      mkdir “$(backupPath)”
      displayName: ‘Create backup directory’

    • script: |
      sqlcmd -S $(sqlServer) -U $(sqlUser) -P $(sqlPassword) -Q “BACKUP DATABASE [$(selectedDatabase)] TO DISK = N’$(backupPath)$(backupFileName)’ WITH NOFORMAT, INIT, NAME = N’$(selectedDatabase)-Full Database Backup’, SKIP, NOREWIND, NOUNLOAD, STATS = 10”
      displayName: ‘Backup SQL Database’

• stage: Restore
  dependsOn: Backup
  condition: and(succeeded(), eq(dependencies.Backup.result, ‘Succeeded’))
  jobs:
  • job: RestoreDatabase
    steps:
    • script: |
      sqlcmd -S $(sqlServer) -U $(sqlUser) -P $(sqlPassword) -Q “RESTORE DATABASE [$(selectedDatabase)] FROM DISK = N’$(backupPath)$(backupFileName)’ WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5” -o “$(backupPath)restore_log.txt”
      displayName: ‘Restore SQL Database’

this is my script