Toad World® Forums

How do I Scheduling a procedure to run

what’s the best way to schedule a procedure to run using TOAD for Oracle Expert 12.0.0.61 on a Windows 2008 server?

I thought perhaps I could do something through Automation Designer, but cant seem to find it there. I’m at a loss on how to do it.

Jerry

Hi,

Nice explanation of Toad automation is here:
www.toadworld.com/.../task-automation-in-toad-174-saving-you-hours.aspx

Check that Automation works as requested (test manula start)

After that define scheduler (Windows Scheduler) on previously defined program.

Right click on wanted automation program.

And in Windows Scheduler this looks like:

Hope this helps…

Thanks Damir.

Do you (or anyone else) have an idea of what I select, or how I would use this to run a procedure within a package body using the automation?

Utilities|Automation Designer … new (right click).
Then next screen:

Sample output looks like (in c:\temp directory):

begin
my_pkg.py_proc ();
End;

Error at line 1
ORA-06550: line 2, column 3:
PLS-00201: identifier ‘MY_PKG.PY_PROC’ must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

Hope this helps …