What is job manager?

In SQL Server, job is defined as a multistep operation. Each step is a Transact-SQL as a task possibly. Job is a typical task planning and automate tasks. Database backup and recovery, data copy, data import / export, etc. can be defined as Job, and then in the planning time auto-complete with SQL Server Agent.

Creating a Job:

1. Run "SQL Server Enterprise Manager", and log onto specified server, then click "management" -> "+" in the left of SQL Server Agent;
2. Right-click "Jobs", choose "New Job", open the dialog box of New Job Properties. Choose the properties of new job;
3. In tab of "General", and defined the properties "Name", "Category", "Owner", "Description";
4. Choose tab of "Steps", and then click "new" button, open the dialog box of "New Job Steps";
5. Choose "Advanced" in the dialog box of "New Job Steps";
6. Choose "Schedules", click "New Schedules" button;
7. Back to the dialog box of New Job Properties, choose tab of Notifications;
8. Click "OK", you have completed the steps required to create a job.

Readers also visit these:

Related Questions: