Online Documentation for SQL Manager for SQL server
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.
- 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.