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

Thread: Automation

  1. 12-19-2002, 12:17 AM #1
    prasadvd
    prasadvd is offline Member
    Join Date
    Nov 2002
    Posts
    115

    Automation

    Hi,

    Can any one answer the following.


    1. I run SQL Loader script to dump the data into Oracle every morning by 8:30. My questios is How to automate this scipt ?

    2. How to automate the Archiving backups ?



    Thnx in adv.
    Prasad
    Reply With Quote Reply With Quote
  2. 12-19-2002, 03:27 AM #2
    stmontgo's Avatar
    stmontgo
    stmontgo is offline Senior Advisor
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    Re: Automation

    Originally posted by prasadvd
    Hi,

    Can any one answer the following.


    1. I run SQL Loader script to dump the data into Oracle every morning by 8:30. My questios is How to automate this scipt ?

    2. How to automate the Archiving backups ?



    Thnx in adv.
    1. put it in cron of have fun writing a little java that will allow u to execute os commands from withing pl/sql that you could schedule through dbms_jobs. Look up our old friend ask tom (http://asktom.oracle.com) and search on o/s commands pl/sql for how to do this.

    2. Cron is probably the best way. Nice note on metalink on understanding cron if you are not familiar with it

    steve
    I'm stmontgo and I approve of this message
    Reply With Quote Reply With Quote
  3. 12-19-2002, 04:17 AM #3
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Most simplest way wud be to write a batch script and put it in NT scheduler.

    Abhay.
    Reply With Quote Reply With Quote
  4. 12-19-2002, 11:26 PM #4
    prasadvd
    prasadvd is offline Member
    Join Date
    Nov 2002
    Posts
    115
    abhy,

    Can u give a sample batch file to put into NT scheduler ?



    Thanx in adv.
    prasadvd@rediffmail.com
    Prasad
    Reply With Quote Reply With Quote
  5. 12-20-2002, 03:15 AM #5
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Prasad:

    I have a batch pgm that will load data into oracle using SQLLDR......
    all u have to do is put it in NT scheduler....set the time u wana run daily.....

    is it okie if i mail u???

    Abhay.
    Reply With Quote Reply With Quote
  6. 12-20-2002, 06:56 AM #6
    prasadvd
    prasadvd is offline Member
    Join Date
    Nov 2002
    Posts
    115
    abhay,

    kindly mail me ur sqlloader script,


    Thnk u very much
    prasadvd@rediffmail.com
    Prasad
    Reply With Quote Reply With Quote
  7. 12-20-2002, 07:29 AM #7
    prasadvd
    prasadvd is offline Member
    Join Date
    Nov 2002
    Posts
    115
    abhay,

    I too have a batch file for SQLLDR script. you just give me steps
    how to put into NT scheduler ?????


    Do u have any idea about archiving backups automation ??????


    Regards,
    prasadvd@rediffmail.com
    Prasad
    Reply With Quote Reply With Quote
  8. 12-20-2002, 08:53 AM #8
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Prasad:

    1) Go to Control panel > Sheduler Tasks.
    2) Click New Schedule Task.
    3) Browse for ur program.
    4) Click Daily then...
    5) Before Finish, check the advanced check box option.
    6) A window pops up .... C wat u want in the Advaned Options n Set accordingly....

    Regards
    Abhay
    Reply With Quote Reply With Quote
  9. 12-21-2002, 12:29 AM #9
    prasadvd
    prasadvd is offline Member
    Join Date
    Nov 2002
    Posts
    115

    Thnx Abhay..

    abhy,

    Thank u very much for giving sch.tasks
    Prasad
    Reply With Quote Reply With Quote
  10. 12-21-2004, 03:41 PM #10
    learning_bee
    learning_bee is offline Senior Member
    Join Date
    Oct 2003
    Posts
    312
    abhaysk,

    could you please give me the batch file for SQLLDR so that I can use TASK Scheduler to schedule the job?????


    thanks,
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width