schedular prob

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kmlgill
    New Member
    • Oct 2007
    • 1

    schedular prob

    hi me trying to use schedular to submit a job in package and getting error
    pls-00201 i.e schedular must be declared
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    Kindly post your code for reference of our experts here in the forum .

    Comment

    • amitpatel66
      Recognized Expert Top Contributor
      • Mar 2007
      • 2358

      #3
      Originally posted by kmlgill
      hi me trying to use schedular to submit a job in package and getting error
      pls-00201 i.e schedular must be declared
      In case if you are using DBMS_SCHEDULAR package then make sure you are performing the below steps:

      1. Create a program (a sub program that you want to schedule)
      2. Create a schedule
      3. Create a job and associate the program to the schedule created in step 2.

      Comment

      Working...