Home » Other » Client Tools » Setup a scheduler in toad (toad: 8++; oracle 9i)
Setup a scheduler in toad [message #331303] Wed, 02 July 2008 23:36 Go to next message
segaraga
Messages: 4
Registered: July 2008
Junior Member
i have a query to be made every sunday at midnight. My pc is client and i have a set of sql statement to query to the server trough my pc. I'm using TOAD to query and i notice a scheduler or job definition to schedule a job.

Appreciate if you're all guys could provide the way to schedule a job to query to database reside on server. How do i achieve this if my pc is turn on and have to log in to domain for achieving this objective.

Thanks in advance
Re: Setup a scheduler in toad [message #331309 is a reply to message #331303] Wed, 02 July 2008 23:45 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Sounds to me like the wrong approach. I don't think it's a good idea to schedule this on the client.
Schedule it on the server; after all, the server is always on, the server does not need to make a connection through the network, etc.
Depending on the type of action, you can either run a job in the database itself, or use cron to start a sqlplus process.
Re: Setup a scheduler in toad [message #331376 is a reply to message #331309] Thu, 03 July 2008 03:43 Go to previous messageGo to next message
segaraga
Messages: 4
Registered: July 2008
Junior Member
thanks for replying. But i need the result to be in MS excel format. Do you have any idea?
Re: Setup a scheduler in toad [message #331390 is a reply to message #331376] Thu, 03 July 2008 04:03 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
And what can your pc, using TOAD do, that sqlplus on the server cannot?
Re: Setup a scheduler in toad [message #331392 is a reply to message #331390] Thu, 03 July 2008 04:09 Go to previous messageGo to next message
segaraga
Messages: 4
Registered: July 2008
Junior Member
using toad to convert the result to excel format. I just plan to use windows scheduler but can't see a way to perform it. Thanks
Re: Setup a scheduler in toad [message #331395 is a reply to message #331392] Thu, 03 July 2008 04:11 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Simply spool the results as a csv file (many examples here on this site).
Re: Setup a scheduler in toad [message #331454 is a reply to message #331395] Thu, 03 July 2008 06:36 Go to previous messageGo to next message
segaraga
Messages: 4
Registered: July 2008
Junior Member
that would be sufficient... But do you have the step by step procedure. Thanks
Re: Setup a scheduler in toad [message #331455 is a reply to message #331454] Thu, 03 July 2008 06:44 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Frank wrote on Thu, 03 July 2008 11:11
Simply spool the results as a csv file (many examples here on this site).

Previous Topic: Download link for OracleDevsuite 10g
Next Topic: Need SQL Query
Goto Forum:
  


Current Time: Thu Mar 28 03:40:04 CDT 2024