DBMS_JOBS [message #10934] |
Tue, 24 February 2004 23:53 |
Kchitij
Messages: 13 Registered: October 2002
|
Junior Member |
|
|
I need to make every user active after 24 hours he is made inactive due to unsuccessful login. How do I accomplish it using DBMS_JOBS. or is there any other procedure of doing it.
Earlier replies will be appreciated.
Regards
Reema
|
|
|
Re: DBMS_JOBS [message #10945 is a reply to message #10934] |
Wed, 25 February 2004 05:20 |
ashok
Messages: 32 Registered: July 2000
|
Member |
|
|
Procedure make_active as
begin
ALTER USER <<username>> ACCOUNT UNLOCK;
end ;
declare
VARIABLE jobno number;
BEGIN
DBMS_JOB.SUBMIT (
:jobno, --Job
'make_active', -- what to run
sysdate , -- First run
sysdate +1 ) ; --Interval
commit;
END;
/
|
|
|
|