How would I run each aspect of Ola Halengren's sql maintenance plan on SQL Express?
It's my understanding that each job should be run in a specific order. I'm sure that a .bat or cmd file can do this, but not sure where/how to start. SQL Express does not show the Server Agent, so the jobs do not display.
Can I view them another way and still use the scheduler, or would I have to script those? Would I have to run that from Task Scheduler, or can the SQL Agent scheduler handle this? Any help/direction you could provide is greatly appreciated.
On a side note, I'm also wondering if jobs can be scheduled to run after another job completes, as opposed to specifying a time to run the job?