Elastic​Database​Jobs

databasejobs-module" sourceFile="azureelasticdbjobsps/0.8.33/ElasticDatabaseJobs/index.md" sourceStartLineNumber="2" sourceEndLineNumber="2">ElasticDatabaseJobs Module

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-​Azure​Sql​Job​Child​Target

Associates a target to a custom collection target.

Get-​Azure​Sql​Job

Gets one or multiple job definitions.

Get-​Azure​Sql​Job​Content

Gets content containers to run or apply across entities in a target.

Get-​Azure​Sql​Job​Content​Definition

Gets one or multiple content definitions that are run or applied across entities within a job target.

Get-​Azure​Sql​Job​Credential

Gets one or multiple database credentials to use when connecting to databases for execution of jobs.

Get-​Azure​Sql​Job​Execution

Gets one or multiple job execution containers.

Get-​Azure​Sql​Job​Execution​Policy

Gets one or multiple job execution policies.

Get-​Azure​Sql​Job​Schedule

Gets one or multiple job schedules.

Get-​Azure​Sql​Job​Script​Batch​Execution

Gets one or multiple results of a script batch execution within a task execution.

Get-​Azure​Sql​Job​Target

Gets one or multiple containers of databases that can be used as a target for job runs.

Get-​Azure​Sql​Job​Task​Execution

Gets one or multiple task run results.

Get-​Azure​Sql​Job​Trigger

Gets one or multiple job triggers.

New-​Azure​Sql​Job

Creates a job definition to be used for subsequent job runs.

New-​Azure​Sql​Job​Connection

Creates a connection to an Elastic Database jobs database.

New-​Azure​Sql​Job​Content

Creates content that can be run or applied across entities within a job target.

New-​Azure​Sql​Job​Credential

Creates database credentials when connecting to databases to run jobs.

New-​Azure​Sql​Job​Execution​Policy

Creates an execution policy which controls job execution timeouts.

New-​Azure​Sql​Job​Schedule

Creates a time based specification for a job run to take place either on a reoccurring interval or at a single time.

New-​Azure​Sql​Job​Target

Creates a set of databases that can be used as a target for jobs.

New-​Azure​Sql​Job​Trigger

Creates a mapping of job to schedules.

Remove-​Azure​Sql​Job

Removes a job and its job run history from the system.

Remove-​Azure​Sql​Job​Child​Target

Removes a child target from another target.

Remove-​Azure​Sql​Job​Trigger

Removes a job trigger to stop future jobs runs according to a schedule.

Set-​Azure​Sql​Job

Updates a job definition.

Set-​Azure​Sql​Job​Content​Definition

Sets the T-SQL script or DACPAC URI definition of content.

Set-​Azure​Sql​Job​Credential

Updates the username or password within an existing credential.

Set-​Azure​Sql​Job​Execution​Policy

Sets a job execution policy.

Set-​Azure​Sql​Job​Schedule

Updates a schedule.

Set-​Azure​Sql​Job​Target

Updates a job target definition.

Set-​Azure​Sql​Job​Trigger

Sets a job trigger.

Start-​Azure​Sql​Job​Execution

Starts a job execution.

Stop-​Azure​Sql​Job​Execution

Stops a job execution.

Use-​Azure​Sql​Job​Connection

Sets the Azure PowerShell session context to use the provided connection to the Elastic Database Jobs control database.

Wait-​Azure​Sql​Job​Execution

Waits for the provided job execution to complete.