Online Documentation for SQL Manager for SQL server

Create a scheduled job


SQL Server provides a possibility to run jobs automatically without user interaction, i.e. you can define event or date to start the job.

A job can be scheduled by creating a new schedule for the job, or by attaching an existing schedule to the job.

There are two ways to create a new schedule

  • right-click the Schedules node (within the Server Objects branch) in the DB Explorer tree and select the New Schedule item from the context menu and configure schedule options in the Schedule Editor.
  • right-click the Jobs node (within the Server Objects branch) in the DB Explorer tree and select the New Job item from the context menu. In the Job Editor when Managing job schedules right-click within the work area to call the context menu and select the Add Schedules... item. Configure parameters of the new schedule in the New Schedule dialog.

 

To attach an existing schedule right-click the Jobs node (within the Server Objects branch) in the DB Explorer tree and select the New Job item from the context menu. In the Job Editor when Managing job schedules right-click within the work area to call the context menu and select the Add Existing Schedule item. Then choose the necessary schedule from the list.