Unix - Cron Job Help


 
Thread Tools Search this Thread
Operating Systems HP-UX Unix - Cron Job Help
# 1  
Old 12-24-2008
Unix - Cron Job Help

Up until now I used Oracle's Enterprise manager to submit the batch job. However its SMTP function (Sends EMail about Job status) is unstable lately. I want to use Unix's Cron to submit my batch job. This way I can also eliminate the middle layer (Oracle's Enterprise manager). Please help how I can do this...

This is what I want

----Job1
----Job2
--------Job3
------------Job4
----------------Job5

Means Job1 will start .Job1 fails or comples successfully I want Job 2 to start. After that all subsequent jobs are dependent on success of previous job. Means Job3 must start only if Job2 completes successfully.

Job3 depends on Success of Job2
If Job2 failes...whole cycles halts right there.

Job4 depends on Success of Job3
If Job3 failes...whole cycles halts right there.

Job5 depends on Success of Job4
If Job4 failes...whole cycles halts right there.

Once all this is done I want to send the emaiil along with the Job output.

All my jobs are nothing but submitting a OS COmmand

Example .
Job1 --

sqlplus -s user/password @/level1/scripts/data_flush.sql

Job2.

sqlplus -s user/password @/level1/scripts/data_load_step1.sql

So on and so forth...

Please help
# 2  
Old 12-24-2008
Why do you need seperate jobs?

Code:
if <command>; then
  if <command>; then
    if <command>; then
      <command>
    fi
  fi
fi

Padow
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Cron job - Need to run Cron every quarter at particular time

Hi, 1) If some job supposed to run on 1st of every month at 7 AM In cron job when we have a blackout on the 1st ( i.e when 1st falls on a sunday ) how can we make the job run the next business day? 2) How can we run a job on 25th of every quarter 7 AM(jan,apr,jul,oct) And if 25th... (5 Replies)
Discussion started by: System Admin 77
5 Replies

2. Shell Programming and Scripting

UNIX command for checking the cron job failures?

Hi- I need to set a mail trap for checking the cron job filures in a server. I have many cron jobs running in our server. What unix command will identify the failed cron jobs? Your thoughts please!!!!! (6 Replies)
Discussion started by: ChandruBala73
6 Replies

3. Shell Programming and Scripting

Commented cron job -- cron monitoring

Hi I have a requirement to write a shell script,that will check the all commented job in cron job.Please help !! (2 Replies)
Discussion started by: netdbaind
2 Replies

4. Solaris

Cron job running even after cron is removed

Hi , I have removed a cron for particular user , but cron job seems to be running even after the cron entry is removed. The purpose of the cron was to sendmail to user ( it uses mailx utility ) I have restarted cron and sendmail service still user is getting mail alerts from the cron job. And... (4 Replies)
Discussion started by: chidori
4 Replies

5. Shell Programming and Scripting

how to run a script using cron job and send the output as attachment via e-mail using unix

how to run a script using cron job and send the output as attachment via e-mail using unix. please help me. how my cron job entry should be? As of now my cron job entry is to run the script at specific time, 15 03 * * * /path/sample.sh | mail -s "Logs" email_id In the above entry, what... (8 Replies)
Discussion started by: vidhyaS
8 Replies

6. Shell Programming and Scripting

Cron Job help

I need to write the cron job for the following scenario, Please help me out The CRON job runs sometime at night on Saturday and checks if there are more than eight files in the /PROCESSED folder. Any files over and above eight are deleted based on ascending order of date (eight most recent... (10 Replies)
Discussion started by: sandeep.dwivedi
10 Replies

7. Solaris

cron job starts new cron proccess

I run cron in solaris 10 zone. One cron job which syncing files to nfs mounted on container, creates after finishing another cron proccess(/usr/sbin/cron), and after 100 existing cron proccesses next cron job will not start. It's too weird for me, I'm not able to solve this problem. Theoretically... (3 Replies)
Discussion started by: ron76
3 Replies

8. Solaris

cron job

hi, how i woulsd be able to find that my cron job is running or not.. E.g abc (2 Replies)
Discussion started by: sam.whocares
2 Replies

9. UNIX for Dummies Questions & Answers

CRON usage for CRON job

can anybody explain the usage of CRON for adding a cron job. please provide an example also for better understanding !!! Thanks (1 Reply)
Discussion started by: skyineyes
1 Replies

10. UNIX for Dummies Questions & Answers

Cron JOB

I have a cron job that ran for 3 months; all the suden, it stops working. There were no changes in the script. Is there away that I can find out why? can someone with root permission disable my cron-job? Is there away that I can look into the system to see who may have done that? My cron job... (1 Reply)
Discussion started by: bobo
1 Replies
Login or Register to Ask a Question