• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 507
  • Last Modified:

ORACLE JOB

Hi,
I created Stored Procedure that need to run every 15 minutes.
I tested with SQL, works fine...
begin
update_sad_header('BG','TR');
end;

I tested as well: update_sad_header('KG','AF'); and works fine...
Can someone help me to create JOB with those two parameters (arguments)?

Thank you
0
andrejaTJ
Asked:
andrejaTJ
  • 4
  • 2
1 Solution
 
Alexander Eßer [Alex140181]Software DeveloperCommented:
classic DBMS_JOB would look like this:

begin
  sys.dbms_job.submit(job => :job,
                      what => 'update_sad_header(''KG'',''AF'');',
                      next_date => sysdate,
                      interval => 'sysdate + 15/1440');
  commit;
end;

Open in new window


This starts the job immediately.
0
 
andrejaTJAuthor Commented:
Thank you Alex,
I'm getting error:

[Err] ORA-01008: not all variables bound

This is not creating job :(
Best,
Andreja
0
 
Alexander Eßer [Alex140181]Software DeveloperCommented:
Sorry, my bad ;-)

declare
l_job binary_integer;
begin
  sys.dbms_job.submit(job => l_job,
                      what => 'update_sad_header(''KG'',''AF'');',
                      next_date => sysdate,
                      interval => 'sysdate + 15/1440');
  commit;
end;

Open in new window

0
Managing Security Policy in a Changing Environment

The enterprise network environment is evolving rapidly as companies extend their physical data centers to embrace cloud computing and software-defined networking. This new reality means that the challenge of managing the security policy is much more dynamic and complex.

 
Alexander Eßer [Alex140181]Software DeveloperCommented:
Thanks for accepting my comment as the solutions, BUT why do I get that "B" penalty?!
0
 
andrejaTJAuthor Commented:
Sorry...
How I can change the grade?!
Best,
0
 
Alexander Eßer [Alex140181]Software DeveloperCommented:
Thanks a lot ;-)

Cheers,
Alex
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now