How can I change the target database for an Azure Elastic Job?

Simon Graham 25 Reputation points

I have an existing Azure Elastic Job which targets an Azure SQL database and executes once daily. I need to change the target database for the existing elastic job.

I have found the following column which contains the name of the current target

Does anyone know if it's ok to simply update this column value or is there more to it?

Azure SQL Database
{count} votes

Accepted answer
  1. ShaktiSingh-MSFT 11,136 Reputation points Microsoft Employee

    Simon Graham

    Below is the response from internal team:

    You should not update internal tables/views.  That can corrupt the Jobs DB and make your jobs fail. They are for querying/read only. You can use the stored procedures that are installed on your Jobs DB to add/delete target groups/members.

    Hope this helps.

    Let us know if you have further queries.


0 additional answers

Sort by: Most helpful