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

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Thu, 25 May 2000 13:00:24 -0300
Message-Id: <10508.106710@fatcity.com>

I have problems with the AT command on NT sometimes.

e.g. when we changed the time in the Fall, half the NT servers stopped executing AT jobs.

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.

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

After rebooting the machines the AT jobs started functioning again.

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

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

	The NT "AT" command won't work?  I use it all the time.
	Ron Smith
	Database Administration
	rlsmith_at_kmg.com


	-----Original Message-----
	Sent: Thursday, May 25, 2000 9:49 AM
	To: Multiple recipients of list ORACLE-L
	interval


	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.

	HTH,

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

	=3D=3D=3D=3D=3D
	Rocky Welch
	Oracle DBA Consultant

	rockyw_99_at_yahoo.com

	__________________________________________________
	Do You Yahoo!?
	Kick off your party with Yahoo! Invites.
	http://invites.yahoo.com/
	--=20
	Author: Rocky Welch
	  INET: rockyw_99_at_yahoo.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
	(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

	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 May 25 2000 - 11:00:24 CDT