With SQL Server 2000 I can set up my maintenance plan but it will not run.
No log files are created. There are no indications what so ever about why th
e
plan will not run. Another SQL Server 2000 will run maintenance plans fine.
Has anyone run across this issue and if so, what did you do to fix the
problem. Thanks.Creating and scheduling a maintenance plan will just create
a job that executes xp_sqlmaint to execute the specific
maintenance plan. So you want to verify that the job is
actually created, that SQL Server Agent is running, check
the job history itself for the maintenance plan job, etc.
-Sue
On Wed, 6 Sep 2006 14:33:02 -0700, Jodi Venneri <Jodi
Venneri@.discussions.microsoft.com> wrote:
>With SQL Server 2000 I can set up my maintenance plan but it will not run.
>No log files are created. There are no indications what so ever about why t
he
>plan will not run. Another SQL Server 2000 will run maintenance plans fine
.
>Has anyone run across this issue and if so, what did you do to fix the
>problem. Thanks.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment