topic Re: run schedule batch file in Operating System - HP-UX

run schedule batch file

tareq_2 — Thu, 01 Oct 2009 07:23:53 GMT

hi there

i have hp-ux 11i v1 and i want to run batch file in my OS every 1 month and another batch file every week . but i dont know how to do that
any help please

regards

Re: run schedule batch file

Dennis Handly — Thu, 01 Oct 2009 07:32:09 GMT

From crontab(1):
minute hour monthday month weekday command
00 00 01 * * command # first of month
00 00 * * 0 command # every sunday

Just adjust the MM, HH, MD and WD fields and desired.

Re: run schedule batch file

Raj D. — Thu, 01 Oct 2009 07:51:47 GMT

Tareg,

If you want to run the batch using root privilege:

1. Login to root.
2. Keep a backup using # crontab -l > crontab.orig
3. Use #crontab -e [ To edit crontab ]

4. Add the below entry with the batch script name & path,

00 00 01 * * /home/user/batch1 # 1st of Every Month, midnight.
00 00 * * 1 /home/user/batch2 # Every Sunday midnight.

5. Save with :wq!
6. Veryfy with : # crontab -l
7. Wait for execution on schedule date and check...

________________________________________
FYI:
first 5 entry in cron represents as below:
- minute (0-59),
- hour (0-23),
- day of the month (1-31),
- month of the year (1-12),
- day of the week (0-6 with 0=Sunday).

* more : # man crontab
_________________________________________

Cheers.
Raj.

Re: run schedule batch file

tareq_2 — Thu, 01 Oct 2009 12:20:44 GMT

thanks for help
but now i face problem in makeing my batch file my batch file is oracle sql command.
what i need
1. login to oracle user
2. run sqlplus
3. run the sql command
how i can collect these steps in batch file and shedule this file.
please find the attached file its contain the sql comman.
any help please.
thanks

Re: run schedule batch file

Raj D. — Thu, 01 Oct 2009 12:59:52 GMT

You can run this with su command.
Ex: # su - oracle -c command_file

Re: run schedule batch file

tareq_2 — Sat, 03 Oct 2009 04:55:09 GMT

thank for help i will do that