Announcement

Collapse
No announcement yet.

Executing The Procedure in the database

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

  • Executing The Procedure in the database

    Hi all,

    I have created a Procedure in the qa environment, and the procedure is not allocated or scheduled for otm jobs,.

    but i want to see the procedures last executed date and time in the database, can u folks help me on this
    Thanks
    Gokul

  • #2
    Re: Executing The Procedure in the database

    Gokul,

    I may be wrong, but I'm not aware of anywhere within the Oracle database this is listed, unless the procedure is scheduled via the Oracle Job Queue Facility -- in which case it tracks the running (and past runs) of that particular procedure.


    --Chris
    Chris Plough
    twitter.com/chrisplough
    MavenWire

    Comment


    • #3
      Re: Executing The Procedure in the database

      In addition to what Chris has specified -

      1) You can put a insert_date column for the data inserts/updates/refresh that is being attempted through the procedure.That can tell you for sure when the procedure completed. If it is a data refresh, then it will tell you the start and end dates.

      2) Alternatively, if procedure is triggered through the agent, you can check the logs to know the timings

      or

      3) give notify message centres before and after the procedure run to check the start and end timings in the message centre

      Any more?

      Comment

      Working...
      X