Online Documentation for SQL Administrator 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.
SQL Server Agent jobs can be used to simplify SQL Server administration and make it more efficient by automating routine administrative tasks.
Note: Before using SQL Server jobs, make sure that the SQL Server Agent service is running.
Use the object context menu or toolbar buttons to:
create a new job
edit selected job(s)
drop selected job(s)
- rename job
- enable job(s)
- disable job(s)
start job(s)
- stop job(s)
view job history
create and print the report
The list displays all created jobs as a grid with the following columns: Name, Category, Enabled, Execution Status, Last Run Outcome, Last Run Date, Next Run Date, Schedules, Creation Date, Owner, Description. If more convenient, you can change the order of the columns by dragging their headers horizontally. See the Working with grid section of the SQL Administrator documentation to find out operations that can be performed with the grid.
To open a job in the Job Editor, double-click it in the grid. Alternatively, you can right-click the job alias and select the Edit Job context menu item.
See also:
