Skip to Main Content
Oracle PL/SQL for DBAs
book

Oracle PL/SQL for DBAs

by Arup Nanda, Steven Feuerstein
October 2005
Intermediate to advanced content levelIntermediate to advanced
454 pages
14h 44m
English
O'Reilly Media, Inc.
Content preview from Oracle PL/SQL for DBAs

Specifying an End Date for Windows

DBMS_SCHEDULER allows you to specify a date when a window will end. What does that mean?

Suppose that your accounting database receives data from an outside source. You discover that the outside source has been compromised and that the data coming from there is not accurate. You decide to code a stored procedure that will fix the data in the database, and use a schedule to execute this procedure every day. However, the source for this fix is available to you only until August 2nd, and today is July 5th. After August 2nd, you want this job to end. You defined a window in the first place so that this job will not consume all your resources. Because the issue will be resolved by August 2nd, you want the window to have a definite lifespan. To effectively end this window on that day, and thus conserve resources, you could specify an end date when you create the window. You do this with the end_date parameter of the CREATE_WINDOW procedure .

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL Best Practices

Oracle PL/SQL Best Practices

Steven Feuerstein
Expert Oracle PL/SQL

Expert Oracle PL/SQL

Ron Hardman, Michael McLaughlin
Oracle PL/SQL For Dummies

Oracle PL/SQL For Dummies

Michael Rosenblum, Paul Dorsey

Publisher Resources

ISBN: 0596005873Supplemental ContentErrata Page