OraFAQ Forum: Server Administration » Running a Job when Server Starts

Home » RDBMS Server » Server Administration » Running a Job when Server Starts

Mon, 19 August 2002 01:19

Rajesh Naik
Messages: 6
Registered: January 2002

Junior Member

Hi all

I want to run a Job when Oracle Server Starts. Please tell me how to do it .

Thanks

Mon, 19 August 2002 04:28

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

you can use an after startup trigger ( in 8i and above ) to run the stored procedure or sql statement
that does the job.
something like this

CREATE OR REPLACE TRIGGER fires_after_startup
AFTER STARTUP ON DATABASE
begin
  do_this...
  do_that...
end;

Previous Topic:	ORA-12571: TNS:packet writer failure
Next Topic:	Job_queue_processes Parameter is not Changing

Goto Forum:

]

Current Time: Thu Dec 26 10:25:36 CST 2024