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