-
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
-
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
-
Most simplest way wud be to write a batch script and put it in NT scheduler.
Abhay.
-
abhy,
Can u give a sample batch file to put into NT scheduler ?
Thanx in adv.
prasadvd@rediffmail.com
Prasad
-
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.
-
abhay,
kindly mail me ur sqlloader script,
Thnk u very much
prasadvd@rediffmail.com
Prasad
-
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
-
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
-
Thnx Abhay..
abhy,
Thank u very much for giving sch.tasks
Prasad
-
abhaysk,
could you please give me the batch file for SQLLDR so that I can use TASK Scheduler to schedule the job?????
thanks,
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
|