Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 464
  • Last Modified:

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.
0
anumoses
Asked:
anumoses
1 Solution
 
slightwv (䄆 Netminder) Commented:
You would need to add the code to the package.
0
 
anumosesAuthor Commented:
That was what I thought. Thanks for confirming.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

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