dbms_job.submit question
DECLARE
x NUMBER;
BEGIN
DBMS_JOB.SUBMIT
( job => X
,what => 'daily_ht_don_pros_match_p
,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.
x NUMBER;
BEGIN
DBMS_JOB.SUBMIT
( job => X
,what => 'daily_ht_don_pros_match_p
,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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER