I have seen it where once a week is good enough, but i have also seen it where it needed to be run every two hours to keep the application performance where it needed to be. Really comes down to "it depends."

Please note, where it was being run every two hours, it was on a single, large, volitale table.