Home » RDBMS Server » Server Administration » Urgent!!!!!!!!!!! Call sql file in job
Urgent!!!!!!!!!!! Call sql file in job [message #52721] Thu, 08 August 2002 03:17 Go to next message
Vincent KOUAKOU
Messages: 5
Registered: July 2002
Junior Member
How can i call a sql file in job ?

the sql file contains some sql commands :
connexion to some databases
extract some data
produce some sql report

how can i call this file or execute it from a job ?

Report message to a moderator

Re: Urgent!!!!!!!!!!! Call sql file in job [message #52724 is a reply to message #52721] Thu, 08 August 2002 05:29 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
wat kind of JOB are u speaking about?
cron jobs (OS level )then write a shell script
to connect to database and run the script.
or
using dbms_job (inside the database) then convert the sql into stored procedure

Report message to a moderator

Previous Topic: Recovery Schemes used in Oracle
Next Topic: SQLPLUS login problems
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 18:16:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.