Announcement

Collapse
No announcement yet.

Table name for 'View Scheduled Jobs'

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Table name for 'View Scheduled Jobs'

    Hi All

    Any one know the table name where i can find the list of scheduled jobs , timings, emails etc.,

    REPORT_LOG table is having the records which are already run.

    Sam

  • #2
    Re: Table name for 'View Scheduled Jobs'

    Hi,

    You could try the following SQL:

    select * from PROCESS_CONTROL_REQUEST where is_transient='N' and next_process_time is not null order by process_control_request_id desc

    Antony
    Antony Carter
    Mavenwire

    www.MavenWire.com

    Comment


    • #3
      Re: Table name for 'View Scheduled Jobs'

      Hi Antony

      I guess this table is for recurring processes.

      I am looking for scheduled report jobs.
      Business Process automation -> Reporting -> View Scheduled jobs ,
      Select 'scheduled jobs' and click 'Go'

      Comment


      • #4
        Re: Table name for 'View Scheduled Jobs'

        Sam,

        If you're using OTM 5.x then the scheduler resides on the Oracle Reports Server and as far as I know is not accessible (it's in a binary file). For OTM 6.1 the scheduled report jobs are inserted in the process_control_request table.

        Thanks,
        Alan
        Last edited by acuartero; November 4, 2010, 17:52.

        Comment


        • #5
          Re: Table name for 'View Scheduled Jobs'

          Alan
          We are using 5.5. Thanks for the info

          Comment


          • #6
            Re: Table name for 'View Scheduled Jobs'

            Hi Alan,

            where we can find the location of scheduler resides on the Oracle Reports Server ?

            currently there are about 25000jobs are scheduled in OTM, we need to kill as reports are getting hung.

            Comment

            Working...
            X