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

Thread: dbms_job vs cron jobs

  1. #1
    Join Date
    Jan 2001
    Posts
    2,828
    i need to run jobs at predifned intervals of time and we have decided to automate this jobs i was wondering what to do use dbms_jobs package supplied by oracle or use cron and a shell script.

    my task inculde

    a)taking incremental exports
    b)cleaning up archived log directory
    c)other routine space administration tasks and paging them 2 a dba.

    i am runing oracle 8.1.6 on redhat linux.source code or shell script examples to achieve the above tasks would be of great help.

    thanks in advance

    [Edited by hrishy on 02-22-2001 at 03:18 AM]

  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    looking at the tasks ,I would go for cron jobs.

    Regards
    Gert

  3. #3
    Join Date
    Jan 2001
    Posts
    18
    For A and B, Use Shell scripts.

    For C, Use DBMS_JOB package.

    Thanks.

    Best Regards.

    S. Sundar,
    Technical Specialist,
    Computer Software & Solutions,
    Muscat,
    Sultanate of Oman.

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828

    Wink

    great answer folks but being new to this job ,wish somebody could provide me with the source code for doing this both for dbms_job and cron shell scripts i would be greatful.even websites would be great.

    thanks for all the help




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