DBMS_JOBS Questions

[rakgol_a]

How does one create a Oracle Jobs using
DOA C++ Builder.

Example, I want to schedule stored procedure
with two parameters. SP_MYPROC(X number, Y number);

Above code exmaple???

 

[Marco Kalter]

The following code will schedule your procedure every other day, starting tomorrow. The parameter values are 2 and 100 for X and Y.

{
  int Job;

  MainSession->DBMS_Job->Submit(Job, "sp_myproc(2, 100);", Date() + 1, "sysdate + 2", false);
  ShowMessage("Job = " + IntToStr(Job));
}

------------------
Marco Kalter
Allround Automations