Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    41

    Unanswered: Running a Sql query from Crontab.

    Hi,

    I want to run a sql query from a crontab.
    I hav written a script which enters SQLPLUS , executes the query and directs the output to a flat file.

    My problem is when Iam palcing the script in crontab it is throwing an error .But when executed in the prompt ,it is running.

    pls give ur suggestions on that.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you don't spell the name of the script correctly, then SQL Plus will throw an error.

    As you probably guessed, I'm trying to be funny. Without you providing information about the error being thrown, we have to guess at it. There's a pretty wide area for guessing!

    Please be more specific. Cut the error message from the log (SQL Plus output) file, and post it here. If possible (without security or related problems), cut the whole command you are using, and post that here too.

    With all of the people that contribute here, I'm sure that someone can help you if you can give them the information that they need to do that!

    -PatP

Posting Permissions

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