Toad World® Forums

How do I schedule a SQL to run in batch


#1

I have an SQL script that updates columns in a table. I’d like to schedule this to run every hour. What are the steps to set this up in Toad?

I have Toad expert v12.12.0.39

Thanks

Below is the SQL:

UPDATE OBJ_REL_TRANSACTION SET STATUS = 3 WHERE OBJRELTRANID IN
(
select to_number(transaction_id) from
(
select t.taskid ETL_task_id, t.name etl,
OBJRELTRANID transaction_id
from task t
join task_pset p on p.taskid = t.taskid
join OBJ_REL_TRANSACTION obj on obj.srcid = t.srcid
where tasktypeid = 300
and etlmodid = 148
and insertts > trunc(sysdate)
and status = -1
and rowcount <=10
order by rowcount asc
)
)


#2

Go to Schema Browser, Scheduler Jobs tab. Create a schedule job for this SQL (as a PL/SQL block) Don’t forget to include the commit.

-John


#3

That works. Thanks!

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Tuesday, March 13, 2018 9:56 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] How do I schedule a SQL to run in batch

RE: How do I schedule a SQL to run in batch

Reply by John Dorlon

Go to Schema Browser, Scheduler Jobs tab. Create a schedule job for this SQL (as a PL/SQL block) Don’t forget to include the commit.

-John

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.