How to use Job in Oracle 8i

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Tue, 05 Jul 2005 9:49 am

Have Customers with Oracle 9i and 8i, put together a process that uses calls to the Job to run at the Bank without Locking the screen, and enabling the process scheduling.
US Banks 10 g and 9i Beauty, but in the 8i Job creates but does not run.
See:
Code: Select all
declare
  v_job number;
BEGIN
  dbms_job.submit(v_job,'null;',sysdate,'sysdate');

  DBMS_JOB.WHAT(v_job,' begin
                          insert into thiago values (''carregou'');
                          commit;
                        end; ');

commit;

END; 
the Job Created:
Code: Select all
SQLWKS> select * from user_jobs
     2>
JOB        LOG_USER                       WHAT
---------- ------------------------------ --------------------------------------
         26 MAXICON                          begin insert into thiago values               
                                                           (''carregou'');
                                                           commit;
                                                       end;

but if I query the table that should you entered
Code: Select all
SQLWKS> select * from thiago
     2>
DS_ERRO                                                                         
--------------------------------------------------------------------------------
0 linhas selecionadas.
could Someone let me know if you have any Particularity?
Some parameter of the Bank that I should Change?
TBou
Location: Campo Grande - MS

Thiago Bourscheidt
thiago.info@apoiorural.com.br
Analista de Sistemas

Poston Wed, 06 Jul 2005 9:07 am

Very weird ...

Tried it on 9i and it really worked. (I'm not a 8i here, but I'll try in my house)

Try doing the following select, to see if he reportedly rode:
Code: Select all
SQL> select to_char(last_date, 'dd/mm/rr-hh24:mi:ss') last_date
  2  ,      to_char(next_date, 'dd/mm/rr-hh24:mi:ss') next_date
  3  from user_jobs
  4  where job=26
  5  /

LAST_DATE         NEXT_DATE
----------------- -----------------
06/07/05-09:09:56 06/07/05-09:09:56

SQL>
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered

Poston Thu, 07 Jul 2005 3:36 pm

Ai Gagotão ... iuhu ... I got is senguinte, this parameter has q be 10 but in Oracle 8i the Default is 0 see
Code: Select all
SELECT value FROM V$PARAMETER
WHERE NAME LIKE '%job%'
but ai still that way doesn't work have q put a commit in the Middle you see
Code: Select all
declare
v_job number;
BEGIN
dbms_job.submit(v_job,'null;',sysdate,'sysdate');
COMMIT;
DBMS_JOB.WHAT(v_job,' begin
insert into thiago_teste values (''carregou'');
commit;
end; ');
commit;
END;
TBou
Location: Campo Grande - MS

Thiago Bourscheidt
thiago.info@apoiorural.com.br
Analista de Sistemas

Poston Tue, 16 May 2006 4:46 pm

Friend, I was seeing your code and would like to know how you implemented this?
You had to make an interface, where all inserts in Bank would be triggered by this job, I'm in need of something for programmers do a create table straight into production and I think this job help me well, I'm sure of it? Need anything else besides implement an interface?

Thanking you in advance!
ERIKAFURLAN
Location: Brasilia-DF

Poston Mon, 29 May 2006 4:45 pm

Hello girl.

following the Job is a process that runs in the Bank releasing the screen forms.

What I did was assemble a table that handled and returned to me the status of the running JOB but for you create a table in Windows system do not know if it will help a lot for that you could maybe a EXECUTE_IMEDIATE
TBou
Location: Campo Grande - MS

Thiago Bourscheidt
thiago.info@apoiorural.com.br
Analista de Sistemas


  • See also
    Replies
    Views
    Last Post


      Return to PL/SQL

      Who is online

      Users browsing this forum: Bing [Bot] and 3 guests