Short Description
Over-Run Jobs monitor was created to monitor PeopleSoft jobs that are running above the permissible threshold time limits
Reason for us to create PeopleSoft Over Run Jobs Monitor
There was a production incident where one of the finance job was running over 5 days during vacations period and has created major problem with cyclic financial jobs So, there was a request from Director, Enterprise Solutions of a company to provide a solution to proactively monitoring and reporting of late running jobs in PeopleSoft process scheduler.
I had to put some thoughts to come up with some monitor that could permanently resolve the problem and also do proactive monitoring of late running jobs. Today, I am excited to announce that I have complete workable solution to proactively detect and report the late running jobs in PeopleSoft with added cool features to easily manage the monitoring and reporting of late running jobs using web "Control Center"
Unique features of OverRun Jobs Monitor are as follows
1) Ksh Scripting with Custom CSS template
2) PHP and Apache
3) Oracle Adapters for PHP
4) Excel Pivot tables and ODBC Drivers for Oracle
Over-Run Jobs monitor was created to monitor PeopleSoft jobs that are running above the permissible threshold time limits
Reason for us to create PeopleSoft Over Run Jobs Monitor
There was a production incident where one of the finance job was running over 5 days during vacations period and has created major problem with cyclic financial jobs So, there was a request from Director, Enterprise Solutions of a company to provide a solution to proactively monitoring and reporting of late running jobs in PeopleSoft process scheduler.
I had to put some thoughts to come up with some monitor that could permanently resolve the problem and also do proactive monitoring of late running jobs. Today, I am excited to announce that I have complete workable solution to proactively detect and report the late running jobs in PeopleSoft with added cool features to easily manage the monitoring and reporting of late running jobs using web "Control Center"
Unique features of OverRun Jobs Monitor are as follows
- A Web Control Center (CC) to easily set and manage the threshold run limits of the jobs using the web browser. Once the running job cross the Threshold limits the notification email is triggered.
- It’s also possible to Enable or Disable Monitoring of specific jobs by setting the monitoring flag.(0=Enable, 1=Disable)
- User can manually Add, Remove and Update the Jobs using the same control Center.
- Added user email address field to facilitate users specific email notification for over-running jobs. (Controlled email notifications)
- Historical Run Time Analysis of the Jobs are made possible using well know Excel Pivot tables and Charts. (Provided the SQL and DB Connect String for the same)
- Improved the HTML report format in the email by adding a Custom CSS styles sheet to Sqlplus
- Live Job Run Dashboard is also possible using the excel charts (Provided the SQL for the same)
- Auto Discovery of New Jobs and to monitoring during next run.
1) Ksh Scripting with Custom CSS template
2) PHP and Apache
3) Oracle Adapters for PHP
4) Excel Pivot tables and ODBC Drivers for Oracle
No comments:
Post a Comment