Set-​Azure​Sql​Job​Trigger

Sets a job trigger.

Syntax

Set-AzureSqlJobTrigger
   [[-AzureSqlJobConnection] <AzureSqlJobConnection>]
   -Enabled <Boolean>
   -JobName <String>
   -ScheduleName <String>
   [<CommonParameters>]

Description

The Set-AzureSqlJobTrigger cmdlet sets a job trigger.

Examples

Example 1: Disable job executions from the job trigger

PS C:\>Set-AzureSqlDatabaseJobTrigger -JobName "MyJob" -ScheduleName "MySchedule" -Enabled $False

This command disables further job executions from the job trigger that binds the job named MyJob and the schedule named MySchedule.

Required Parameters

-Enabled

Indicates whether the trigger is enabled.

Type:Boolean
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-JobName

Specifies the name of the job.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-ScheduleName

Specifies the name of the schedule.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

Optional Parameters

-AzureSqlJobConnection

Specifies the connection state object for the job. You can get the connection state object through the New-AzureSqlJobConnection cmdlet. If you do not specify this parameter, the connection state is used from a prior call to the Use-AzureSqlJobConnection cmdlet.

Type:AzureSqlJobConnection
Position:1
Default value:None
Accept pipeline input:False
Accept wildcard characters:False