How to design a Maintenance plan from Command prompt and use a DTS package for the steps?
This is the question asked in MSDN forums, using SQLMAINT utility this can be achieved and also the output can be sent to a text file or HTML file. In case if the steps are defined in the DTS package then its best to use DTEXEC utility. Best to refer to books online (updated) for more information on these command line utilities.