I have a Stored procedure.
How to create/ submit/ schedule a job IN TOAD to run this SP every day at 6am
Thanks a lot
Linh Vu
Set the Schema Browser to “Scheduler Jobs”, click the “Create” toolbar (looks like a clean sheet of paper) and fill in the details in the dialog.
On the “Schedule Info” tab, set it to “Specify Schedule Info”. You can right-click on the “Interval” edit box for some samples of the format, but this will give you every day at 6 am.
FREQ=DAILY;INTERVAL=1;BYHOUR=6; BYMINUTE=0;BYSECOND=0
On the “Program Info” tab, set it to “specify” and you can specify your stored procedure name there.
Thanks a lot John
Have a nice day
Linh Vu
Database Administrator
Cell: 612-760-4968
Ceridian, 17390 Brookhurst Street, Fountain Valley, CA 92708
From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]
Sent: Wednesday, August 19, 2015 11:13 AM
Subject: RE: [Toad for Oracle - Discussion Forum] Create job in TOAD
Reply by John Dorlon
Set the Schema Browser to “Scheduler Jobs”, click the “Create” toolbar (looks like a clean sheet of paper) and fill in the details in the dialog.
On the “Schedule Info” tab, set it to “Specify Schedule Info”. You can right-click on the “Interval” edit box for some samples of the format, but this will give you every day at 6 am.
FREQ=DAILY;INTERVAL=1;BYHOUR=6; BYMINUTE=0;BYSECOND=0
On the “Program Info” tab, set it to “specify” and you can specify your stored procedure name there.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
----------------------------------------- IMPORTANT: The sender intends that this electronic message is for exclusive use by the person to whom it is addressed. This message may contain information that is confidential or privileged and exempt from disclosure under applicable law. If the reader of this message is not an intended recipient, be aware that any disclosure, dissemination, distribution or copying of this communication, or the use of its contents, is prohibited. If you have received this message in error, please immediately notify the sender of your inadvertent receipt and delete this message from all data storage systems. Thank you.