I am running SQL 2005 Standard SP3 on Microsoft Windows NT 5.2 (3790)
This is a two node active/active cluster.
I had a maintenance plan that was called from the command line by a third party scheduler (Tidal) and everything ran fine. Then a new copy of the maintenance plan was created with additional code and named with _new at the end. The new plan ran
fine interactively (right click and execute). The old plan was renamed to _old and the new plan renamed to remove the _new. The scheduler will no longer run the maintenance plan. I have attempted to run the plan manually from the command
line, as the scheduler would do. It finds the plan, says its starting and then runs for 6 seconds (should be about 50 minutes) and says it completed successfully, but obviously did not. The history of the plan does not show any execution.
I have tried exporting the plan, dropping it and reimportng (jiggling the handle), I have also exported he old plan and dropped it, thinking there might be some internal name glitch. I have no idea what is going on, but need to get the plan to run from
the command line--forgetting the scheduler for the moment, the manual run from the command line does not work. (I'll worry about the scheduler later). The command that is being run is:
dtexec /SQL “Maintenance Plans\ProvDUpeCln_CKN
View Complete Post