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.