| Setup a scheduler in toad [message #331303] |
Wed, 02 July 2008 23:36  |
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  |
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
