RE: Long Running Jobs From SQL Worksheet

From: Jack Silvey <JSilvey_at_XOL.com>
Date: Thu, 13 Jul 2000 17:27:10 -0500
Message-Id: <10557.111999@fatcity.com>

Patrice,

A good answer is to give the user with a telnet session that links to = the
server, have her put her SQL scripts on the server, and schedule a job = that
calls sql*plus and runs the script. This way, the job is running on the server, and does not rely on a network connection to finish. She can = then
close her telnet session and the job will still run.

If the user needs to see what happened during the job, make the script = write
a spool file to the server and look at it.

Jack=20
ocp x 2
senior @ xol.com

-----Original Message-----
From: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca] Sent: Thursday, July 13, 2000 10:26 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Long Running Jobs From SQL Worksheet

Maybe you have no choice in the matter, but my preference would be to = use
plus80.exe (not plus80w.exe unless you like Dr. Watson errors) , in = silent
mode, with the -s switch.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

	-----Original Message-----
	From:	Bill Wagman [SMTP:wjwagman_at_ucdavis.edu]
	Sent:	Thursday, July 13, 2000 12:04 AM
	To:	Multiple recipients of list ORACLE-L
	Subject:	Long Running Jobs From SQL Worksheet

	Hello,

	A user connects to our 8.0.5 oracle server on an NT 4.0 machine, via
phone=20
	from home, and submits sql queries which may run for a long time,
greater=20
	than 2 hours. Because of restrictions on our campus modem pool the=20
	connection is dropped after 2 hours. If the job is not completed it
is=20
	terminated.

	Is it possible to submit 'batch' jobs from sql worksheet and if so
how can=20
	it be set up?

	Thanks.

	Bill Wagman
	Univ. of California at Davis
	Information Resources
	wjwagman_at_ucdavis.edu


	(530) 754-6208

=09

------------------------------------------------------------------------=

Why is it that when you're driving and looking for an address, you turn=20

down the volume on the radio?=20

	--=20
	Author: Bill Wagman
	  INET: wjwagman_at_ucdavis.edu

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L


	(or the name of mailing list you want to be removed from).  You may

	also send the HELP command for other information (like subscribing).

--=20
Author: Boivin, Patrice J
INET: BoivinP_at_mar.dfo-mpo.gc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Thu Jul 13 2000 - 17:27:10 CDT