cron job scheduling

chinatrain99 · #1 (**permalink**) 08-25-06, 12:42

I'd like to kick off a DB2 backup using cron. I want it to run at 2:00 a.m. every 4th Sunday. Is there a way to do this?

LKBrwn_DBA · #2 (**permalink**) 08-25-06, 13:09

Not unless you write a script that runs every sunday and "counts" if that is the 4th sunday, or try this:

00 02 * * 0 [ $(echo "`date +%d`\n7\n/\np\nq"|dc -) -eq 4 ] && /path/to/db2bckp/bckDB2.ksh

PS: Default shell must be bash or ksh (not sh)

chinatrain99 · #3 (**permalink**) 08-25-06, 13:22

someone gave me this to run the 1st sunday of the month...which is what i really wanted anyway...

0 1 1-7 * * [‘date + \%a ‘ = Sun] && /db2scripts/reorgjob.sh

LKBrwn_DBA · #4 (**permalink**) 08-25-06, 13:29

Yeah, similar idea -- Good luck!

Internet Services

Web Development

Digital Marketing

Consumer Tech