Solved

dbms_job.submit question

Posted on 2013-01-24
2
458 Views
Last Modified: 2013-01-24
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
Comment
Question by:anumoses
2 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 250 total points
ID: 38814529
You would need to add the code to the package.
0
 
LVL 6

Author Closing Comment

by:anumoses
ID: 38814548
That was what I thought. Thanks for confirming.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question