Adding JOb

Hi,

To execute a procedure I write in SQL *PLus : exec slr_updplcrecipes_pcr(P_PROCESS_CELL => 'Forming')

This works.

Now I've create a procedure for adding jobs with text:

dbms_job.isubmit(2, 'slr_updplcrecipes_pcr(' || chr(39) || P_PROCESS_CELL => 'Forming' || chr(39) || ');', to_date('9-may-2012 10:00','dd-Mon-yyyy hh24:mi'), 'trunc(sysdate+(30/24/60), ''MI'')');  

And this is not correct. I've tried several inputs, but i get a compile error or it doesn't work.

Can anyone help me with the right syntax?

Thanks.