Home » RDBMS Server » Server Administration » Re: I want to write a job
Re: I want to write a job [message #51260] Fri, 10 May 2002 05:29
Robert Kuhlmann
Messages: 35
Registered: March 2002
Member
Try this

SQL> create or replace procedure nix
2 as
3 begin
4 null;
5 end;
6 /

Prozedur wurde angelegt.

SQL> var v_nix number
SQL> exec dbms_job.submit(:v_nix,'nix;', last_day(sysdate), 'last_day(sysdate)');

PL/SQL-Prozedur wurde erfolgreich abgeschlossen.

Report message to a moderator

Previous Topic: How to find who is holding a temp segment in 7.3.4 ?
Next Topic: Unable to Install Oracle8i on Windows XP Home Edition
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 09:54:50 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.