RE: Execute a procedure depending upon time or at a regular inter

From: Guidry, Chris <chris.guidry_at_atcoelectric.com>
Date: Fri, 26 May 2000 13:43:49 -0600
Message-Id: <10509.106917@fatcity.com>

Hi
I have had problems in the past also. I therefore now use Task Scheduler. Runs much better. If you have IE 4 you can download it as an add on. IE 5 has it. IE 4 -- Administrative Tools
IE 5 -- My Computer

HTH -
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: chris.guidry_at_atcoelectric.com

> -----Original Message-----
> From: Boivin, Patrice J [SMTP:BoivinP_at_mar.dfo-mpo.gc.ca]
> Sent: Thursday, May 25, 2000 11:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Execute a procedure depending upon time or at a regular
> inter

>=20

> I have problems with the AT command on NT sometimes.
>=20
> e.g. when we changed the time in the Fall, half the NT servers =
stopped
> executing AT jobs.

>=20
> It could be an obscure setting somewhere, but you never really know =
on NT
> there is no way to diagnose the internals of the OS.

>=20

> No error was generated anywhere, the jobs just didn't run.

>=20

> After rebooting the machines the AT jobs started functioning again.

>=20

> This type of thing doesn't happen often, but it does happen.

>=20

> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)

>=20


> 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

>=20

> E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20
> =09
> -----Original Message-----
> From: Smith, Ron L. [SMTP:rlsmith_at_kmg.com]
> Sent: Thursday, May 25, 2000 12:19 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Execute a procedure depending upon time or at a
> regular inter

>=20


> 	The NT "AT" command won't work?  I use it all the time.

> 	Ron Smith

> 	Database Administration

> 	rlsmith_at_kmg.com

>=20
>=20


> 	-----Original Message-----

> 	Sent: Thursday, May 25, 2000 9:49 AM

> 	To: Multiple recipients of list ORACLE-L

> 	interval

>=20
>=20


> 	Hi Swajit,

> 	Consult the Oracle documentation about the DBMS_JOB package which

> works

> 	just like Unix cron. The good part is that it is internal to Oracle

> and

> 	the database.

>=20


> 	HTH,

>=20


> 	--- Swajit Satam <swajit_at_mahindrabt.com> wrote:

> 	> Hi

> 	>=20

> 	>     Can I Execute a procedure depending upon time or

> 	> say at a regular interval (like Triggers but triggers are

> 	> event driven ).

> 	> If it's a Unix box then I can write a cron job but if it's a NT

> Box then

> 	> it cannot be achived so can it be done inside Oracle itself so

> that i

> 	> dont have to depend no O/S. or is there any work around for the

> same.

> 	>=20

> 	>=20

> 	> TIA

> 	> Swajit

> 	>=20

> 	>=20

> 	>=20

> 	>=20

> 	> --=20

> 	> Author: Swajit Satam

> 	>   INET: swajit_at_mahindrabt.com

> 	>=20

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


> 	=3D=3D=3D=3D=3D

> 	Rocky Welch

> 	Oracle DBA Consultant

>=20


> 	rockyw_99_at_yahoo.com

>=20


> 	__________________________________________________

> 	Do You Yahoo!?

> 	Kick off your party with Yahoo! Invites.

> 	http://invites.yahoo.com/

> 	--=20

> 	Author: Rocky Welch

> 	  INET: rockyw_99_at_yahoo.com

>=20


> 	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: Smith, Ron L.

> 	  INET: rlsmith_at_kmg.com

>=20


> 	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

>=20


> 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 May 26 2000 - 14:43:49 CDT