2026.8.26.3

Overview
Name elasticjobagent
Tag 2026.8.26.3
FullName br:bicepacrdevwcom.azurecr.io/bicep/modules/elasticjobagent:2026.8.26.3
Last updated 2026-08-26 07:45:38:+00:00
Created 2026-08-26 07:45:38:+00:00
Digest sha256:1fad8ae67022a74907fed0a97e0268a142b4637d30cb2a7694f82ee43d5231a1

Parameters

Name Type Required Description
env string Yes The environment to be created
version string Yes Version number
location string No
resourceGroup().location
 Location for all resources
system string Yes System/project name
prefix string Yes Prefix
tags object Yes Tags to add to the resources
identityType string
'SystemAssigned',
'SystemAssignedUserAssigned',
'UserAssigned',
'None'
 No
'UserAssigned'
 What kind of identity does the elastic agent use, default UserAssigned
userAssignedIdentities string No
'system'
 Managed Identity Resource Id
useSystemAssignedIdentity bool No
false
 If System Assigned Managed Identity is to be used, set this to true, default is false
sku string
'JA100',
'JA200',
'JA400',
'JA800'
 No
'JA100'
 SKU for agent.
sqlServerName string Yes Sql server name
sqlDB string No
'ElasticJobs'
 Name of the database that will store all agent and job info. Default is ElasticJobs
sqlTargetGroupsAndJobs array No
[
]
 Use this as template:
var sqlTargetGroupsAndJobs = [
{
name: 'GroupName'
serverName: 'ServerName'
serverResourceGroupName: 'serverResourceGroupName'
serverSubscriptionId: 'serverSubscriptionId'
databaseName: 'DatabaseName'
membershipType: 'Include/Exclude', default Include (Optional)
type: 'SqlDatabase/SqlElasticPool/SqlServer/TargetGroup'
jobs: [{
name: 'JobName'
description: 'JobDescription'
enabled: true/false
interval: 'PT1H for every hour (ISO 8601)'
startTime: '0001-01-01T00:00:00Z' (Optional, only honored when endTime is also set)
endTime: '9999-12-31T11:59:59Z' (Optional, only honored when startTime is also set)
type: 'Once/Recurring'
steps: [{
name: 'StepName'
query: 'QueryToRun'
initialRetryIntervalSeconds: int, default 1 (Optional)
maximumRetryIntervalSeconds: int, default 120 (Optional)
retryAttempts: int, default 10 (Optional)
retryIntervalBackoffMultiplier: int, default 2 (Optional)
timeoutSeconds: int, default 43200 (Optional)
output: { (Optional) write the step result set to a table; table is auto-created
serverName: 'DestinationServer'
databaseName: 'DestinationDb'
tableName: 'OutputTable'
schemaName: 'dbo' (Optional, default dbo)
type: 'SqlDatabase' (Optional, default SqlDatabase)
credential: 'credentialResourceId' (Optional, omit to use the agent managed identity)
resourceGroupName: 'rg' (Optional, for cross-resource-group destinations)
subscriptionId: 'subId' (Optional, for cross-subscription destinations)
}
}]
}]
}
]
databaseCollation string No
'SQL_Latin1_General_CP1_CI_AS'
 Elastic job database collation, default is SQL_Latin1_General_CP1_CI_AS
databaseSku string No
'S0'
 Database SKU for Elastic Job database, default is S0

Outputs

Name Type Description

Example

@description('The target environment.')
param env string

@description('The deployment version.')
param version string = '1.0.0.0'

@description('System/project name')
param system string

@description('Prefix')
param prefix string

@description('Tags to add to the resources')
param tags object

@description('Sql server name')
param sqlServerName string


module elasticjobagent 'br:bicepacrdevwcom.azurecr.io/bicep/modules/elasticjobagent:2026.8.26.3' = {
    name: 'elasticjobagent${env}${version}'
    params: {
      env: env
      version: version
      system: system
      prefix: prefix
      tags: tags
      sqlServerName: sqlServerName
    }
}