Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    148

    Unanswered: Scripting Reccomendation

    Hi all. I dont have much experience in this area and I just wanted to know if I could get some advice in terms of how to get started on this...

    Basically, I need something to do a simple select statement with a where clause from a DB. The where statement will be a variable that is input, and the the script should execute the query every X minutes - which will be an input variable as well.

    So something like:
    X = 10 (minutes)
    Y = Green
    L = Last Time query fired

    So every X minutes the query is run:

    Select * From table_Name where Col_Name = 'y'
    Variable L = Now
    If results are found
    carry out this logic
    Else
    do nothing
    End

    Seems like a simple enough idea. My question is what language would be appropriate for this? Namely my concern of the language stems from wondering how the program/script is going to stay in a running state...It's going to have to fire every X minutes without being manually triggered. Any ideas on where to get started on this would be great i thank you for your help.

  2. #2
    Join Date
    Apr 2004
    Posts
    246
    if all the "carry out this logic" is in the db, the dbms_job is best
    Give a man a fish, you feed him for a day. Club him over the head with a fish, he'll leave you alone.

  3. #3
    Join Date
    Dec 2003
    Posts
    148
    The "carry out this logic" is basically emailing some information...

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Use UTL_SMTP to send email messages from PL/SQL procedures.
    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 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    dbms_job will work, However if you are on a unix system, cron has more flexibility
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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