Automating SQL scripts in Toad for Oracle

Question

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.

Consider posting your question on dba.stackexchange.com

EvilTeach
– EvilTeach

2019-10-21 18:34:48 +00:00
Commented Oct 21, 2019 at 18:34 — EvilTeach
– EvilTeach, Commented Oct 21, 2019 at 18:34

Littlefoot · Accepted Answer · 2019-10-21 18:53:36Z

1

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.

answered Oct 21, 2019 at 18:53

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Automating SQL scripts in Toad for Oracle

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related