Online Documentation for SQL Manager for SQL server
Shared schedules are multipurpose items that contain ready-to-use schedule information. You can create a shared schedule once, and then reference it in a subscription or property page when you need to specify schedule information.
Before using SQL Server schedules, make sure that the SQL Server Agent service is running.
Schedule Editor allows you to define schedule properties. It opens automatically when you create a new schedule and is available on editing an existing one.
To open a schedule in Schedule Editor, double-click it in the DB Explorer tree or in the Shared schedules manager. Alternatively, you can right-click the schedule alias and select the Edit Schedule context menu item.
- Using Navigation bar and Toolbar
- Setting schedule properties
- Viewing scheduled jobs
- Viewing DDL definition
To create, edit and drop schedules, you can also use the context menu and the Navigation bar of Shared schedules manager.