I need help to create a cron job

Cron job that runs daily every hour that does this:

cd /u1/database/prod/arch
chmod -R o+rw /u1/database/prod/arch
gzip -f -r *

First type all of those commands into a file and change the owner of the file to the user you expect to run the file. Make the file executable by that user.

Next read:

man cron

and

man 5 cron

The latter will show you the fields of the cron file and how to use them.

Login as the user to execute the cron and type:

crontab -l >my.crontab

Add this line to the file

0 * * * * /path_to_the_executable

Type:

crontab my.crontab

and cron will be updated

Type crontab -l to confirm your new line has been added.

(I had typed crontab -L, when I meant crontab -l ) --little ell

How do I make the file executable?

try chmod 755 somefilehere

I am not sure if 755 is the ideal permission you want to set but man the chmod command to get a better idea of what you might want to set your permission level.