thanks for the prompt reply......but it would be more clear to me if we take an example...lets suppose we want to run this command after every 2 hrs....just an example:
select * from users
i put it in a file named try.sql and run it using START command.....now i want to run this file try.sql...
Hello,
i am new to sql scripting....i am working with a database related software and i need to execute a certain set of statements in oracle after every 2 hrs......i have written the statements in a .sql file and when i run the file using START command, it runs fine...but how do i automatically...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.