Jobs in ORACLE

Thread View: comp.databases.oracle.misc

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by wolfgang karrer Mon, 22 Nov 1999 00:00

#118

Author: wolfgang karrer
Date: Mon, 22 Nov 1999 00:00

35 lines
1652 bytes

Hi, i ve a Question concerning Jobs in ORACLE:


How is it possible to control a date column by the database if the sysdate
is equal to the date: Example

I ve a table like

SLIDE
name VARCHAR2(10),
abstract VARCHAR(500);
relDate DATE
released CHAR (1)

if the actual date (sysdate) is equal to the relDate in the table SLIDE i
want to update the released col in 'N'. How is this possible???

Thanks in advance for helping me!!

--
Wolfgang Karrer
B�ro f�r EDV-Dienstleistungen
Gewerbegasse 6
4060 Leonding
Tel + Fax. (0732) 681795
Mobil: (0699) 134 18 469
EMail: w.karrer@ooenet.at
---------------------------------------
Institut f�r Wirtschaftsinformatik
Abteilung Communications Engineering
o.Univ.- Prof. DI Dr. Christian Stary
Freist�dterstr. 315
4040 Linz/Urfahr
Tel: (0732) 2468-7104
EMail: wolfgang.karrer@ce.uni-linz.ac.at

Re: Jobs in ORACLE

#119

Author: Em Pradhan
Date: Mon, 22 Nov 1999 00:00

49 lines
2095 bytes

Hi
you can run a scheduled job depending on the
operating sistem (cron or at ) so that it
checks the database every day and if
finds the release date = system date
then update the released column.
like
if release date <= sysdate and released = 'N' then
update released = 'Y' where condition matches.

HTH
pradhan

wolfgang karrer wrote:

> Hi, i ve a Question concerning Jobs in ORACLE:
>
> How is it possible to control a date column by the database if the sysdate
> is equal to the date: Example
>
> I ve a table like
>
> SLIDE
> name VARCHAR2(10),
> abstract VARCHAR(500);
> relDate DATE
> released CHAR (1)
>
> if the actual date (sysdate) is equal to the relDate in the table SLIDE i
> want to update the released col in 'N'. How is this possible???
>
> Thanks in advance for helping me!!
>
> --
> Wolfgang Karrer
> B�ro f�r EDV-Dienstleistungen
> Gewerbegasse 6
> 4060 Leonding
> Tel + Fax. (0732) 681795
> Mobil: (0699) 134 18 469
> EMail: w.karrer@ooenet.at
> ---------------------------------------
> Institut f�r Wirtschaftsinformatik
> Abteilung Communications Engineering
> o.Univ.- Prof. DI Dr. Christian Stary
> Freist�dterstr. 315
> 4040 Linz/Urfahr
> Tel: (0732) 2468-7104
> EMail: wolfgang.karrer@ce.uni-linz.ac.at

Re: Jobs in ORACLE

#120

Author: ole c meldahl
Date: Tue, 23 Nov 1999 00:00

16 lines
1149 bytes

Em Pradhan wrote:

> Hi
> you can run a scheduled job depending on the
> operating sistem (cron or at ) so that it
> checks the database every day and if
> finds the release date = system date
> then update the released column.
> like
> if release date <= sysdate and released = 'N' then
> update released = 'Y' where condition matches.
>

Why not DBMS_JOB, Oracles pacakge for scheduled tasks?

ole c

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads