Online Documentation for SQL Manager for SQL server

Jobs

A job is a specified set of operations performed sequentially by SQL Server Agent. A job can perform a wide range of activities, including running Transact-SQL scripts, command-line applications, Microsoft ActiveX scripts, Integration Services packages, Analysis Services commands and queries, or Replication tasks. Jobs can run repetitive or scheduled tasks, and they can automatically notify operators of job status by generating alerts.

Before using SQL Server jobs, make sure that the SQL Server Agent service is running.

Job Editor allows you to define job properties. It opens automatically when you create a new job and is available on editing an existing one.

To open a job in Job Editor, double-click it in the DB Explorer tree or in the Jobs manager. Alternatively, you can right-click the job alias and select the Edit Job context menu item.

• Setting job properties
• Managing job steps
• Managing job schedules
• Managing notifications
• Managing target servers
• Viewing DDL definition

To create, edit, rename and drop jobs, you can also use the context menu and the Navigation bar of Jobs manager.