| title | Modify a Job | |||
|---|---|---|---|---|
| ms.prod | sql | |||
| ms.prod_service | sql-tools | |||
| ms.technology | ssms | |||
| ms.topic | conceptual | |||
| helpviewer_keywords |
|
|||
| ms.assetid | dd5e5f20-20c4-4ab9-a19a-db87577dcd43 | |||
| author | markingmyname | |||
| ms.author | maghan | |||
| ms.manager | jroth | |||
| ms.reviewer | ||||
| ms.custom | seo-lt-2019 | |||
| ms.date | 01/19/2017 | |||
| monikerRange | = azuresqldb-mi-current || >= sql-server-2016 || = sqlallproducts-allversions |
[!INCLUDEappliesto-ss-asdbmi-xxxx-xxx-md]
Important
On Azure SQL Database Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Database Managed Instance T-SQL differences from SQL Server for details.
This topic describes how to change the properties of [!INCLUDEmsCoName] [!INCLUDEssNoVersion] Agent jobs in [!INCLUDEssCurrent] by using [!INCLUDEssManStudioFull], [!INCLUDEtsql], or SQL Server Management Objects.
A [!INCLUDEssNoVersion] Agent master job cannot be targeted at both local and remote servers.
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.
-
In Object Explorer, connect to an instance of the [!INCLUDEssDEnoversion], 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.
-
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).