Home » Infrastructure » Linux » Cron Job monitoring
Cron Job monitoring [message #516680] Wed, 20 July 2011 01:08 Go to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

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 messageGo to next message
John Watson
Messages: 8120
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 messageGo to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

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
Re: Cron Job monitoring [message #516690 is a reply to message #516687] Wed, 20 July 2011 01:39 Go to previous messageGo to next message
John Watson
Messages: 8120
Registered: January 2010
Location: Global Village
Senior Member
I can only repeat myself: do it all with the Scheduler. You have determined that cron is not the correct tool.
Re: Cron Job monitoring [message #516699 is a reply to message #516690] Wed, 20 July 2011 02:10 Go to previous message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

Okay..Thanks for your suggestion.
Previous Topic: how to find rpms
Next Topic: Calling .ksh from Oracle 8i pl/sql bolck
Goto Forum:
  


Current Time: Sun Jan 19 21:19:36 CST 2020