O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Job Maintenance

It is not enough to run the Database Maintenance Plan Wizard, set up several jobs, and then let things run. Once you establish jobs, it is important that you:

  • Monitor job status— Review the success or failure of each job.

  • Review job schedules— Review each job for both schedule and frequency.

  • Review job durations— Review how long it took to run the job.

  • Review job outputs— Review log files, backup files, and so on from each job.

To review the success or failure of a job:

1.
From within Enterprise Manager, select the Jobs subnode under the SQL Server Agent mode.
2.
Right-click the job in the right pane whose status you want to monitor, and select View Job History. The Job History dialog box appears (see Figure 15.18A). Here, you ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required