dbms_job.submit question

DECLARE
    x   NUMBER;
BEGIN
    DBMS_JOB.SUBMIT
  ( job       => X
   ,what      => 'daily_ht_don_pros_match_pkg.main;'
   ,interval  => 'SYSDATE+(1/24)'
   ,no_parse  => FALSE
  );
    COMMIT;
END;

I have this job that runs every hour. Wanted to know if there is any parameter here that I can add to only run this package where the update_date is null. Update date is in the table or do I have to add this condition in the package.
LVL 6
anumosesAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
You would need to add the code to the package.
0
 
anumosesAuthor Commented:
That was what I thought. Thanks for confirming.
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.

All Courses

From novice to tech pro — start learning today.