RE: Long Running Jobs From SQL Worksheet

Jack & folks,

I'm supposed to be learning NT, so I would love to hear exactly how you do each of those things on NT (as opposed to Unix, VMS, Netware, etc.).

Basically it sounds like the telnet technique does not rely on client/server archtecture, so you should theoretically be able to do this with no Oracle client software on the PC, no?

Does NT really support a client/server-free "classic" telnet/batch processing model?

My understanding is that with NT, once connected through an ISP, it is possible to login over IP (where you would presumably be able to use char-mode utilities to schedule "independent" batch processes, etc.). If so, why use telnet to get to a NT batch environment?

thanks,
ep

Date sent:      	Thu, 13 Jul 2000 15:35:12 -0800
To:             	Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
From:           	Jack Silvey <JSilvey_at_XOL.com>
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
> 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

...

> 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
> from home, and submits sql queries which may run for a long time,
> greater
> than 2 hours. Because of restrictions on our campus modem pool the
> connection is dropped after 2 hours. If the job is not completed it
> is
> terminated.
>
> Is it possible to submit 'batch' jobs from sql worksheet and if so
> how can
> it be set up?
Received on Thu Jul 13 2000 - 20:59:25 CDT