Does anybody please know and help me setup scheduler to run optimize and repair each weekend (like sunday morning)

I think you can do this using cronjobs. The vBulletin manual may provide some information, since I don't have any experience with this.

Perhaps have a link to this manual where it is explained?

/me hits 1bjoke with a DOH stamp



www.vbulletin.com/docs/html (http://www.vbulletin.com/docs/html)

if you can't find it, it isn't there.

I think you have more luck on vbulletin.org