search

olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution
https://ola.hallengren.com
MIT License
2.88k stars 745 forks source link

Create jobs that contain multiple tasks #101

Open paulvanoordt opened 6 years ago

paulvanoordt commented 6 years ago

I do not find it very practical that so many jobs are created. I usually do a lot of handwork to restructure all the tasks in two jobs, one for daily maintenance, and one for log backups. Especially the backup, reindex, and checkdb actions I would like to be in one job, to prevent them from running simultaneously, or leaving time gaps. The various clean-up tasks can also be easily added there. I understand that sometimes multiple jobs may be needed, especially when using differential backup, or in very big implementations. In my practice that is more an exception than the rule, and of course it could still be in one job with conditions in the steps. So my suggestion would be to either provide an option to create only two jobs, or make that the default.

drstonephd commented 6 years ago

Related to #99

gnotisauton commented 6 years ago

I've rolled my own script that basically composes the jobs I need with a bit of dynamic SQL and a lot of dirty code. Allowing some parameterisation to direct which jobs are created would be helpful.