Job.Alter Method ()
Updates any Job object property changes on an instance of Microsoft SQL Server.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
The Job object since the Job object was created, or since the last statement. The modifications are combined and sent to the instance of SQL Server in a single network trip to the instance of SQL Server.method updates any changes that have been made to the properties of the
Users must have Execute permissions on the msdb.dbo.sp_help_operator stored procedure to script or alter properties on a SQL Server 2000 job.
When connected to an instance of SQL Server 2000, users other than sa do not automatically have permissions to run the msdb.dbo.sp_help_operator stored procedure to any user who has to script or alter a SQL Server 2000 job.method. The system administrator must grant Execute permissions on the
The following code example creates a job, changes a job property, and calls Alter to update the instance.
Server srv = new Server("(local)"); Job jb = new Job(srv.JobServer, "Test Job"); jb.Create(); jb.OperatorToEmail = "OperatorName"; jb.Alter();
$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)") $jb = new-object Microsoft.SqlServer.Management.Smo.Agent.Job($srv.JobServer, "Test Job") $jb.Create() $jb.OperatorToEmail = "OperatorName" $jb.Alter()