2012 Aug 30 4:45 PM
Hi,
I have few background jobs which run every 3 hours. I need to capture the statistics of only these jobs and append them in a custom table so that I have multiple years of statistics to help track performance over time.
Any suggestions ?
regards,
Ashwin.
Hi,
I have few background jobs which run every 3 hours. I need to capture the statistics of only these jobs and append them in a custom table so that I have multiple years of statistics to help track performance over time.
Any suggestions ?
regards,
Ashwin.
2012 Aug 30 5:23 PM
Hi,
You can create a weekly or Monthly job for adding this details to a custom table.
Do a select on TBTCO table and select all the required field by the jobname.
Also, check out FM BP_FIND_JOBS_WITH_PROGRAM.
Thanks,
Shambu
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |