Cron Job monitoring [message #516680] |
Wed, 20 July 2011 01:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Hi,
We have around 400 Crons set for each SQL Reports, the Cron will take the SQL as a parameter and executes it and send the results to a particular email id.
We have around 400 Crons everyday sending data to the users, there are many cases where in the users have complained that the report wasn't received, or they have received very late.
Hence we have to monitor the crons, Please help me in providing the monitoring mechanisms,
1. We cannot open each cron or script and keep our email ids there to track whether it ran or not.
Do we have any alternate approaches ? please suggest.
Regards,
Ashoka
|
|
|
Re: Cron Job monitoring [message #516684 is a reply to message #516680] |
Wed, 20 July 2011 01:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You didn't say what release of Oracle you are using, but if it is 10g or 11g I would use the Scheduler to control all this from within the database. It has excellent facilities for monitoring and taking action in the event of failures.
John.
[update: typo]
[Updated on: Wed, 20 July 2011 01:27] Report message to a moderator
|
|
|
Re: Cron Job monitoring [message #516687 is a reply to message #516684] |
Wed, 20 July 2011 01:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Hi,
We currently use Oracle 10g,but we use different shell scripts to pass many parameters to the SQLs. We do have shell scripts written for monthly reports,daily reports,weekly reports etc..
Regards,
AShoka
|
|
|
|
|