Skip to main content
ExLibris

  • Subscribe by RSS
    • Aleph
    Ex Libris Knowledge Center

    How to tell how long a particular job took

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    How can I tell how long a particular job took to run?

    Resolution:
    You can see how long a particular job took in one of three ways.

    1. On the server, in $alephe_scratch:

    a. > cd $alephe_scratch

    b. Do "ls -lrt" to get the end-time. For example:

    apps-l-a18(1) >>ls -lrt cun50_p_file_20.89710
    -rw-r--r-- 1 aleph aleph 46602 Jul 31 17:06 cun50_p_file_20.8971

    We see that the job ended at 17:06.

    c. "vi" the job log to get the beginning time. In the cun50_p_file_20.8971, we see the following line very near the top:

    SQL*Plus: Release 10.2.0.3.0 - Production on Sat Jul 31 06:00:13 2010

    d. Subtract the start time from the end time. (In this case: 07:02 - 06:00 = 1:02.)

    2. On the server in the $data_files/batch_log file: see KB 16384-30993.

    3. In version 19-up, using the GUI client, you can click on the pencil box ("Admin"), then Task Manager / Batch Log. The display of the different jobs which have run include "Start time" and "End time".

    • Article last edited: 10/8/2013