Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2003
    Location
    Waalwijk, the Netherlands
    Posts
    23

    Thumbs down Unanswered: Database maintenance Plan displays wrong time

    sql200+SP3
    when a DMP is fired for backuping some small databases the job will stay open for 12 hours.
    When i start the job by hand the job is ready in 2 minutes

    Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'AURELIUS' as 'NT AUTHORITY\SYSTEM' (trusted)
    Starting maintenance plan 'DMP ovdb en ServiceDB' on 3-2-2005 21:00:01
    [1] Database ServiceDeskDB: Check Data and Index Linkage...
    ** Execution Time: 0 hrs, 0 mins, 11 secs **
    [2] Database ovdb: Check Data and Index Linkage...
    ** Execution Time: 0 hrs, 2 mins, 2 secs **
    Deleting old text reports... 0 file(s) deleted.
    End of maintenance plan 'DMP ovdb en ServiceDB' on 4-2-2005 10:26:46
    SQLMAINT.EXE Process Exit Code: 0 (Success)

    Johan
    Last edited by jvdrwiel; 02-04-05 at 07:42.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •