Revision history [back]
 | 1 | initial version |
Open SSMS 19.0.1 and connect to the server that hosts the database.
Expand the Object Explorer window and locate the database that contains the tasks you want to handle.
Click on the database to view its contents in the Object Explorer.
Expand the Management folder and right-click on the SQL Server Agent.
Select New and then select the type of task you want to create.
Enter the details of the task and set the schedule.
Click OK to save the task.
To modify an existing task, right-click on the task and select Modify.
Edit the task details and schedule as required.
Click OK to save the changes.
To delete a task, right-click on the task and select Delete.
Click OK to confirm the deletion.