How to take backup of Discourse hourly in a day

That’s not supported using a simple admin setting.

You will need to roll your own pg_dump and uploads script for that.