RE: Long Running Jobs From SQL Worksheet

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Fri, 14 Jul 2000 07:59:25 -0300
Message-Id: <10558.112042@fatcity.com>

Good answer.

Sounded like he wanted to run a script from his PC, so I forgot to = mention
it.

When he mentioned a "long-running job", I should have clued in.

: )

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

Ph: (902) 426-4774

	-----Original Message-----
	From:	Jack Silvey [SMTP:JSilvey_at_XOL.com]
	Sent:	Thursday, July 13, 2000 8:35 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	RE: Long Running Jobs From SQL Worksheet

	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-----
	Sent: Thursday, July 13, 2000 10:26 AM
	To: Multiple recipients of list ORACLE-L


	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>



		-----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

=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

=09

---

                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
	also send the HELP command for other information (like subscribing).
	--=20
	Author: Jack Silvey
	  INET: JSilvey_at_XOL.com

	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

Received on Fri Jul 14 2000 - 05:59:25 CDT