ElasticDatabaseJobs

This topic displays help topics for the Azure Elastic Database Jobs Cmdlets.

Elastic Database Jobs (preview) enables you to reliably run a Transact-SQL (T-SQL) script or apply a data-tier application package (DACPAC) across a group of Azure SQL databases. By using these cmdlets, you can easily perform administrative operations such as schema changes, credentials management, reference data updates, performance data collection, and tenant (customer) telemetry collection.

This module includes preliminary documentation that is subject to change. Blank topics are included as placeholders.

ElasticDatabaseJobs

Add-AzureSqlJobChildTarget	Associates a target to a custom collection target.
Get-AzureSqlJob	Gets one or multiple job definitions.
Get-AzureSqlJobContent	Gets content containers to run or apply across entities in a target.
Get-AzureSqlJobContentDefinition	Gets one or multiple content definitions that are run or applied across entities within a job target.
Get-AzureSqlJobCredential	Gets one or multiple database credentials to use when connecting to databases for execution of jobs.
Get-AzureSqlJobExecution	Gets one or multiple job execution containers.
Get-AzureSqlJobExecutionPolicy	Gets one or multiple job execution policies.
Get-AzureSqlJobSchedule	Gets one or multiple job schedules.
Get-AzureSqlJobScriptBatchExecution	Gets one or multiple results of a script batch execution within a task execution.
Get-AzureSqlJobTarget	Gets one or multiple containers of databases that can be used as a target for job runs.
Get-AzureSqlJobTaskExecution	Gets one or multiple task run results.
Get-AzureSqlJobTrigger	Gets one or multiple job triggers.
New-AzureSqlJob	Creates a job definition to be used for subsequent job runs.
New-AzureSqlJobConnection	Creates a connection to an Elastic Database jobs database.
New-AzureSqlJobContent	Creates content that can be run or applied across entities within a job target.
New-AzureSqlJobCredential	Creates database credentials when connecting to databases to run jobs.
New-AzureSqlJobExecutionPolicy	Creates an execution policy which controls job execution timeouts.
New-AzureSqlJobSchedule	Creates a time based specification for a job run to take place either on a reoccurring interval or at a single time.
New-AzureSqlJobTarget	Creates a set of databases that can be used as a target for jobs.
New-AzureSqlJobTrigger	Creates a mapping of job to schedules.
Remove-AzureSqlJob	Removes a job and its job run history from the system.
Remove-AzureSqlJobChildTarget	Removes a child target from another target.
Remove-AzureSqlJobTrigger	Removes a job trigger to stop future jobs runs according to a schedule.
Set-AzureSqlJob	Updates a job definition.
Set-AzureSqlJobContentDefinition	Sets the T-SQL script or DACPAC URI definition of content.
Set-AzureSqlJobCredential	Updates the username or password within an existing credential.
Set-AzureSqlJobExecutionPolicy	Sets a job execution policy.
Set-AzureSqlJobSchedule	Updates a schedule.
Set-AzureSqlJobTarget	Updates a job target definition.
Set-AzureSqlJobTrigger	Sets a job trigger.
Start-AzureSqlJobExecution	Starts a job execution.
Stop-AzureSqlJobExecution	Stops a job execution.
Use-AzureSqlJobConnection	Sets the Azure PowerShell session context to use the provided connection to the Elastic Database Jobs control database.
Wait-AzureSqlJobExecution	Waits for the provided job execution to complete.