Search for Elastic Job Agents.<\/p>\n<\/li>\n
Click + Create.<\/p>\n<\/li>\n
Choose a Job Database (stores metadata and logs\u2014don\u2019t use your production DB).<\/p>\n<\/li>\n
Review and create.<\/p>\n<\/li>\n<\/ul>\n
<\/p>\n
Elastic Jobs must authenticate to your target databases. You can:<\/p>\n For a managed identity:<\/p>\n Enable it on the Elastic Job Agent under Identity.<\/p>\n<\/li>\n In each target database, create an external user:<\/p>\n<\/li>\n<\/ul>\n ** To create a new Managed Identity (if necessary)<\/p>\n Go to Azure Portal > Managed Identities<\/p>\n<\/li>\n Click + Create<\/p>\n<\/li>\n Choose:<\/p>\n Region: Same as your Job Agent<\/p>\n<\/li>\n Resource group: Same as your Job Agent<\/p>\n<\/li>\n Name: e.g., A target group defines the collection of databases or servers where a job will be executed <\/span>It acts as a container, specifying the scope of the job’s execution.<\/span><\/p>\n Connect to your Job Database using SSMS:<\/p>\n Then add each database:<\/p>\n <\/p>\n <\/p>\n![\"\"](\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2025\/06\/ElasticJobAgentWizard-1.png\")
<\/a><\/p>\n2. Configure Authentication<\/h4>\n
\n
\n
CREATE USER [sqlfreelancer-job-agent-identity] FROM EXTERNAL PROVIDER;<\/code>
\nALTER ROLE db_owner ADD MEMBER [sqlfreelancer-job-agent-identity];<\/code><\/p>\n<\/a><\/p>\n\n
\n
sqlfreelancer-job-agent-identity<\/code><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/a><\/p>\n3. Create a Target Group<\/h4>\n
EXEC<\/span> jobs.sp_add_target_group @target_group_name<\/span> =<\/span> N'TargetGroup_MultipleDBs'<\/span>;
\n<\/code><\/div>\n<\/div>\nEXEC jobs.sp_add_target_group_member <\/code><\/p>\n@target_group_name = N'TargetGroup_MultipleDBs', <\/code><\/p>\n@target_type = N'SqlDatabase', <\/code><\/p>\n@server_name = N'your-server-name.database.windows.net', <\/code><\/p>\n@database_name = N'Database1';<\/code><\/p>\nEXEC jobs.sp_add_target_group_member <\/code><\/p>\n@target_group_name = N'TargetGroup_MultipleDBs', <\/code><\/p>\n@target_type = N'SqlDatabase', <\/code><\/p>\n@server_name = N'your-server-name.database.windows.net', <\/code><\/p>\n@database_name = N'Database2';<\/code><\/p>\nEXEC jobs.sp_add_target_group_member <\/code><\/p>\n@target_group_name = N'TargetGroup_MultipleDBs', <\/code><\/p>\n