Azure Elastic agent job issue. New database has been added to an elastic pool, the job targeting this pool fails execute against the new database
We have a number of elastic agent servers with jobs that target elastic pools. The jobs are still completing successfully for all databases that have existed for some time, but for new databases that are setup and added to the…