ranit B wrote:In that case, if you don't want to change anything, it is better to have a background process in the UNIX box..
This is an existing setup and works pretty well.
Giving grants will be an extra action which in my case can be avoided.
Anyways thanks for the inputs.
In that case, if you don't want to change anything, it is better to have a background process in the UNIX box..Yes, initially I thought that I'll make some <tt>JOBS</tt> and <tt>SCHEDULERS</tt> but then came problems like permissions and all...
But you told that you want to avoid the Unix box. I have seen some DBA related sql scripts scheduled in crontab of the DB server. You may think in that way also.. Don't have much experience in that to make a solid comment..