Question

You manage an Elastic Job agent that runs an index maintenance T-SQL script against all databases on a logical SQL server. A new database named StagingRefresh was added to the same server, but it must NOT be included in the maintenance job because it is dropped and recreated nightly by a separate pipeline. You want the existing job to continue targeting every other database on the server without needing to update the target group each time a new production database is added. What should you configure in the target group?

Accepted Answer

Add a server-level target member for the logical server and add a database-level target member for StagingRefresh with the membership type set to Exclude.

Answer

Add only database-level target members for each production database individually and omit StagingRefresh.

Answer

Add a server-level target member and configure the job step to check DB_NAME() and skip StagingRefresh in the script.

Answer

Create a separate elastic pool target member that contains only the production databases.