Toad World® Forums

Scheduling from Toad

Is it possible to schedule to have code run monthly in Toad?

Not sure about Toad but you can save your sql/plsql in a folder
and create a batch file to kick it off, then use the Windows scheduler

to run it once a month

On Fri, May 19, 2017 at 11:38 AM, smattiko bounce-smattiko@toadworld.com wrote:

Scheduling from Toad

Thread created by smattiko
Is it possible to schedule to have code run monthly in Toad?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle Forum notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.


Gene L. Bradley Jr.

Systems Analyst

Office of Information Technology

Jackson State University

1400 J R Lynch Street

P.O. Box 17750

Jackson, MS 39217

ph 601.979.1042

fax 601.371.9146

email gbradley@jsums.edu

*In God we trust; all others bring data. * ~W.E. Deming

CONFIDENTIALITY STATEMENT

This electronic transmission is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by telephone (601) 979-1042. Thank you.

How do I create a batch file?

open notepad.
name the file something with a .bat extension

file contains the following: note on your system the @instance_name may not be required.


@echo off

echo Running blah… bla… blah… Report

echo Please wait!!!..

sqlplus your_user_name@tns_instance_name/your_password @your_sql_script_name.sql

exit


add this to the op of your sql =====> spool c:\result.txt

add this to the bottom===========> spool off;
============================> exit;

google "run sqlplus script from batch file.

Let me know if this helps

On Mon, May 22, 2017 at 7:21 AM, smattiko bounce-smattiko@toadworld.com wrote:

RE: Scheduling from Toad

Reply by smattiko
How do I create a batch file?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle Forum notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.


Gene L. Bradley Jr.

Systems Analyst

Office of Information Technology

Jackson State University

1400 J R Lynch Street

P.O. Box 17750

Jackson, MS 39217

ph 601.979.1042

fax 601.371.9146

email gbradley@jsums.edu

*In God we trust; all others bring data. * ~W.E. Deming

CONFIDENTIALITY STATEMENT

This electronic transmission is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by telephone (601) 979-1042. Thank you.