Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cron Job

973374Jan 30 2013 — edited Jan 31 2013
Hi,
I am writing a cron job in Oracle 10g(Linux).
So, i have created a script of inseration a data in a table using a cron tab.
sql script which i created is:
vi insert.sql
conn / as sysdba
insert into t1(id) values(01);
commit;
exit

cron Job script :

10 5 * * * /u01/home/insert.sql

but, when i execute this particular file then data is not getting inserted in that particular table.

Please help

Regards,
Rajeev
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2013
Added on Jan 30 2013
9 comments
1,780 views