CODEWITHSUNDEEP
sqloracle-databaseautomationtoad
hootsauce
hootsauce

Reputation: 39

Automating SQL scripts in Toad for Oracle

I'm not a DBA, so bear with me.

I've scheduled tasks through Toad's automation designer, but this uses Windows task scheduler. It's using Oracle 12c.

How can I ensure my scripts execute on time without running a local machine with scheduled tasks? Can this be done without additional software? Thanks in advance.

Upvotes: 1

Views: 904

Answers (1)

Littlefoot
Littlefoot

Reputation: 142705

I don't know what those scripts do.

However, if they can be rewritten into stored procedures, then you could schedule them as database jobs using either DBMS_SCHEDULER (or DBMS_JOB, which is simpler but still quite usable) package.

As a matter of fact, DBMS_SCHEDULER can even run your operating system scripts, using job_type => 'external_script'. Read documentation for more info.

See if it helps.

Upvotes: 1

Related Questions