Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2013
    Posts
    3

    Unanswered: Scheduler based on a table

    I have a scheduler which runs everyday in the morning. This has to be changed and will be triggered based on a column from table 'A'.

    I am new bee, can someone help me with the basics on how to set up this.

    So it has to work like. If the column from table A has a date, then trigger the job

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Words have meanings.
    "TRIGGER" has very specific meaning with regard to Oracle RDBMS.
    a TRIGGER is PL/SQL procedure that gets executed when specific DML action occurs.

    a column which contains a DATE is 100% passive after the value is deposited in the column.
    What code exists that compares column content & compares to SYSDATE to decide if some action should result or not?
    How often does this code run?
    What controls the running of this code?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2013
    Posts
    3
    I dont have any existing code to compare, this will be a new comparison.

    The new code has to check a column in a table and if it exists, then trigger the job. AT present, this job is scheduled to run at 6 AM. After the change, I think it has to be a 'TRIGGER' and it will be based on the column value from a table.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I think it has to be a 'TRIGGER' and it will be based on the column value from a table.
    You think wrongly.

    Oracle Database Search Results: trigger

    You would benefit from Reading The Fine Manual below

    Contents
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    We need more information on your requirements:
    Quote Originally Posted by james.james View Post
    I have a scheduler which runs everyday in the morning. This has to be changed and will be triggered based on a column from table 'A'.
    Explain what is this "scheduler"?
    I am new bee, can someone help me with the basics on how to set up this.

    So it has to work like. If the column from table A has a date, then trigger the job
    So, the above "scheduler" will no longer execute every day in the morning?
    But rather run: 1) On the exact date from the table A or 2) The moment a date column in table A is populated with whatever date?


    Depending on your answers to the above questions, perhaps you could create a trigger on tableA which would submit your "scheduler" procedure each time the "date" column changes.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •