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:
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:
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.