Ask Your Question
3

How to handle tasks in SSMS 19.0.1?

asked 2023-05-24 12:37:52 +0000

plato gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2023-05-24 12:39:03 +0000

djk gravatar image
  1. Open SSMS 19.0.1 and connect to the server that hosts the database.

  2. Expand the Object Explorer window and locate the database that contains the tasks you want to handle.

  3. Click on the database to view its contents in the Object Explorer.

  4. Expand the Management folder and right-click on the SQL Server Agent.

  5. Select New and then select the type of task you want to create.

  6. Enter the details of the task and set the schedule.

  7. Click OK to save the task.

  8. To modify an existing task, right-click on the task and select Modify.

  9. Edit the task details and schedule as required.

  10. Click OK to save the changes.

  11. To delete a task, right-click on the task and select Delete.

  12. Click OK to confirm the deletion.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2023-05-24 12:37:52 +0000

Seen: 8 times

Last updated: May 24 '23