Hi Everyone
I need a help with the one of parameter of DatabaseIntegrityCheck proc in Ola Hallengreen maintenace script. can anyone help me with @DatabaseInParallel parameter?
Thanks,
Dinesh
Hi Everyone
I need a help with the one of parameter of DatabaseIntegrityCheck proc in Ola Hallengreen maintenace script. can anyone help me with @DatabaseInParallel parameter?
Thanks,
Dinesh
What's your question? What do you need help with?
The documentation indicates you need to set up multiple jobs with the @DatabasesInParallel Parameter set to 'Y', and all the other paremeters set to the same value(s).
It appears that you need to set these jobs to all run off the same schedule.
If that's not working, then perhaps @Ola Hallengren himself could sort you out?
If you want to use @DatabaseInParallel, you would need to create multiple SQL Server Agent Jobs, with the exact same command, and that parameter set to 'Y'. If you do that, you will get the integrity checks done in parallel for as many databases as you have jobs.
If you have multiple jobs with the same schedule and NOT have this parameter set to 'Y', your jobs will attempt to run integrity checks on the same database from multiple jobs, which will most probably fail.
16 People are following this question.