Run Script on SQLPlus in Background

Scripts Diversos para o Oracle SQL*Plus. (Relacionado a ferramenta Oracle SQL*Plus, para questões de SQL, usar o forum SQL)
Post Reply
rhpestana
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 10
Joined: Fri, 06 Jun 2008 8:05 am
Location: SP

Hello everyone,

I have the following problem, I am running a script in SQLPlus, this script is scheduled on the Windows task scheduler and works perfectly.

However, I am having to run this script in several bases and in very small time interval, and how it opens a window for each base where it is executed and very small intailment, it is virtually impossible Use my machine.

Is there any way to avoid these windows ????

Thanks,
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

Does this script have to run on your machine?

If only a procedure, you can schedule this with a bank job.
rhpestana
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 10
Joined: Fri, 06 Jun 2008 8:05 am
Location: SP

Hello Tomas,


because it is to put the script in Job, it would be ideal for me ... but unfortunately I can not, would have to rotate on my machine itself ...

And as I said, the time space is very short and appears the window of the type to disturb me at all times ...

how to elminate this, I think SQLPLUS himself opens this window ...
ruevers
Rank: DBA Sênior
Rank: DBA Sênior
Posts: 324
Joined: Fri, 02 Jun 2006 1:48 pm
Location: sp
Contact:

Mano
has a morning for this ... enters the DOS and uses the AT, it's like it was the agented tasks but it is hidden .... it will not open windows, to know how it works in the AT / Help that it gives a summary.


Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 8 guests