|
View previous topic :: View next topic
|
| Author |
Message |
arultm
New User
Joined: 03 Dec 2007
Posts: 7
Location: Mumbai
|
|
|
|
Hi,
I want to unload data from table to dataset by using SQL query in Job to know the exact time taken for unload.
Is there any utility to do it?
If so what are the job steps and what are the details we need to furnish in the job?
Please clarify. |
|
| Back to top |
|
 |
mkk157
Active User
Joined: 17 May 2006
Posts: 310
|
|
|
|
Hi arultm,
If you can observe the spool carefully U can get the time taken for execution of the job.
In the JESMSGLG, U can get these details. Below is the sample.
0------ JES2 JOB STATISTICS ------
- 05 DEC 2007 JOB EXECUTION DATE
- 12 CARDS READ
- 713 SYSOUT PRINT RECORDS
- 0 SYSOUT PUNCH RECORDS
- 42 SYSOUT SPOOL KBYTES
- 0.57 MINUTES EXECUTION TIME |
|
| Back to top |
|
|
arultm
New User
Joined: 03 Dec 2007
Posts: 7
Location: Mumbai
|
|
|
|
I want to know the job to unload the table content when we give SQL query as input?
Can we unload the table content using job?
If so, please let me know how to do it? |
|
| Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006
Posts: 310
|
|
| Back to top |
|
|
arultm
New User
Joined: 03 Dec 2007
Posts: 7
Location: Mumbai
|
|
|
|
| Thank you very much |
|
| Back to top |
|
|
|
|
