Post reply

Time from sysjobhistory and sysjobs

  • February 12, 2003 at 4:18 am

    #80302

    I need to read the sysjobs and sysjobhistory tables to get the date and time that a job started and the duration. After much fruitless reading on the subject and even trying a script from this site I am no further farward - can anyone help?

    REgards

  • February 12, 2003 at 4:26 am

    #448726

    The sysjobhistory table stores this information in the following fields

    run_date (YYYMMDD)

    run_time (HHMMSS)

    run_duration (HHMMSS)

    where exactly is your problem?

  • February 12, 2003 at 6:15 am

    #448730

    I think that now it may be that I dont have one anymore

    Thnaks

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply