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

Simon Graham 25

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
[jobs_internal].[targets].[database_name]

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

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
ShaktiSingh-MSFT 15,921 Reputation points

2023-11-13T08:22:19.8166667+00:00

Hi
Simon Graham,

Welcome to Microsoft Q&A forum.

As I understand, you want to know if you can change the target database for an Azure Elastic Job by simply changing name of column.

I am checking on this question and will get back to you. Thanks

Srini Acharya 86 Microsoft Employee

Simon,

      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. 
https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-tsql-create-manage?view=azuresql#job-stored-procedures
https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-target-group-member-elastic-jobs-transact-sql?view=azuresqldb-current

Hope that helps.

Srini Acharya 86 Microsoft Employee

Simon

     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. 
https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-tsql-create-manage?view=azuresql#job-stored-procedures
https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-target-group-member-elastic-jobs-transact-sql?view=azuresqldb-current

              ```

Accepted answer

ShaktiSingh-MSFT 15,921 Reputation points

2023-11-14T05:20:33.9466667+00:00

Hi
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.

https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-tsql-create-manage?view=azuresql#job-stored-procedures

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-target-group-member-elastic-jobs-transact-sql?view=azuresqldb-current

Hope this helps.

Let us know if you have further queries.

Thanks
Please sign in to rate this answer.
Simon Graham 25 Reputation points

2023-11-15T10:23:44.7866667+00:00

Thanks for the advice. I used the following stored procedures in the job database to update the target...

sp_add_target_group_member (I used this to add the new target DB)

sp_delete_target_group_member (I used this to remove the old target DB)
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

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

0 additional answers

Your answer