Page 1 of 1

How to pull the start time and end time of some of the jobs

PostPosted: Wed Oct 27, 2010 2:52 pm
by Bandita Bahubalendra
Hello Everybody,

I have a requirement like i need to pull the start time and end time of some of the jobs from a database for a certain time period.

For e.g-i want start time and end time of all the jobs ran in between 13/9/2010 to 22/10/2010


Can anybody plz help me on this? how i need to proceed as of now i m doing it manually.

Re: How to pull the start time and end time of some of the jobs

PostPosted: Wed Oct 27, 2010 3:00 pm
by MrSpock
Where are you getting this information from?

Re: How to pull the start time and end time of some of the jobs

PostPosted: Thu Oct 28, 2010 12:58 am
by dick scherrer
Hello,

How does one pull data from a database using jcl. . . :?

Re: How to pull the start time and end time of some of the jobs

PostPosted: Thu Oct 28, 2010 11:16 am
by Bandita Bahubalendra
Hi All,

i m very sorry there is a mistake it is nt from the database........it is from a particular region(testing,production......).

Thanks for rectifying my mistake.

Re: How to pull the start time and end time of some of the jobs

PostPosted: Thu Oct 28, 2010 11:37 am
by expat
Is this another application for the "reinvent the wheel society". In 95% of sites this information is already available from your capacity / performance / billing people. They analyse SMF data on a daily basis and can create reports such as you want in minutes.

Re: How to pull the start time and end time of some of the jobs

PostPosted: Fri Oct 29, 2010 12:06 am
by dick scherrer
Hello,

i m very sorry there is a mistake it is nt from the database........
Not to worry :)

We need to understand the question before we can make many suggestions ;)

If you look into getting what you from SMF, you will need to learn about the info recorded in SMF (which is much more than we can undertake in a forum).

As Expat mentions, what you are looking for most likely already exists.