.png)
Modify a Job
This topic describes how to change the properties of Microsoft SQL Server Agent jobs in SQL Server 2012 by using SQL Server Management Studio, Transact-SQL, or SQL Server Management Objects.
In This Topic
-
Before you begin: ,
-
To modify a job, using:
Limitations and Restrictions
A SQL Server Agent master job cannot be targeted at both local and remote servers.
Security
Unless you are a member of the sysadmin fixed server role, you can only modify jobs that you own. For detailed information, see Implement SQL Server Agent Security.
To modify a job
-
In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
-
Expand SQL Server Agent, expand Jobs, right-click the job you want to modify, and then click Properties.
-
In the Job Properties dialog box, update the job's properties, steps, schedule, alerts, and notifications using the corresponding pages.
To modify a job
-
In Object Explorer, connect to an instance of the Database Engine, and then expand that instance.
-
On the toolbar, click New Query.
-
In the query window, use the following system stored procedures to modify a job.
-
Execute sp_update_job (Transact-SQL) to change the attributes of a job.
-
Execute sp_update_schedule (Transact-SQL) to change the scheduling details for a job definition.
-
Execute sp_add_jobstep (Transact-SQL) to add new job steps.
-
Execute sp_update_jobstep (Transact-SQL) to change pre-existing job steps.
-
Execute sp_delete_jobstep (Transact-SQL) to remove a job step from a job.
-
Additional stored procedures to modify any SQL Server Agent master job:
-
Execute sp_delete_jobserver (Transact-SQL) to delete a server currently associated with a job.
-
Execute sp_add_jobserver (Transact-SQL) to associate a server with the current job.
-
-
To modify a job
Use the Job class by using a programming language that you choose, such as Visual Basic, Visual C#, or PowerShell. For more information, see SQL Server Management Objects (SMO).
