DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Crontab

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    61
    I am running some SQL scripts through Crontab.When it executes those scripts a mail is sent to oracle user in Unix as I am submitting the jobs as Oracle user.I want to send the mail to some other e-mail ids.How I can do this??

    Environment:
    HP-UX 11
    Database Oracle8i R816

    Thanks,

    Ravi

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi Ravi,

    Iam using HP 11.x and database 8.1.6

    Follow these steps

    1) Send the output to a log file by using

    > (Redirection output operator)

    for example

    Jobname > outputfilename

    2) use the following command to send mail

    mailx -m -s "Filename" a@hotmail.com,b@hotmail.com < outputfilename

    Remember to put the full path of your output filename

    Let me know how it goes on.

    Regards
    Santosh

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Either put a .forward in ~oracle's $HOME, or explicitly main the results from your script to your intended parties.
    Jeff Hunter

  4. #4
    Join Date
    Jan 2001
    Posts
    61
    Sanoth/Jeff

    Thanks for the reply.I can send the mails to the specified addresses.

    Thanks,

    Ravi

Posting Permissions

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


Click Here to Expand Forum to Full Width