Microsoft KB Archive/258806

= BUG: Maintenance Job History Does Not Show Correct Durations When a Job Takes Longer Than an Hour =

Article ID: 258806

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q258806



BUG #:57772 (SQLBUG_70)



SYMPTOMS
When you use the Microsoft SQL Server 7.0 Maintenance Plan wizard to create a job, and the job takes more than an hour to run, the duration information in the Maintenance Job history may not be correct. The following example illustrates the problem: Actual Job Duration           Duration in Maintenance Plan History 3600 seconds                  0 minutes, 0 seconds 3601 seconds                  3600 hours, 0 minutes, 1 seconds 3699 seconds                  3660 hours, 1 minutes, 39 seconds 7200 seconds                  7200 hours, 0 minutes, 0 seconds



WORKAROUND
This is only a problem in the Database Maintenance Plan wizard job history. The duration appears correctly in the SQL Server Agent job history.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbbug kbpending KB258806

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.