Database backup job steps

• Pete Bishop

  Default port

  Points: 1498

  More actions

  December 29, 2025 at 9:50 am

  #4708952

  I have a SQL Agent job for backing up a set of Analysis Services databases with each database covered by a different "SQL Server Analysis Services Command" job step of the form:

  {
    "backup": {
      "database": "CUBE NAME",
      "file": "CUBE NAME.abf",
      "allowOverwrite": false,
      "applyCompression": true
    }
  }

  However, if a database is added, deleted or renamed the job fails the particular step - which could result in a database not being backed up.

  Is there a way to write this Agent job so that it can dynamically manage the database names?

  Thanks.