A Task Scheduler And Logger Project

The Tascha utility provides a series of procedures and scripts to help manage your job schedule. It helps to centralise your job schedule where the jobs themselves are (in Oracle) so no operating specific tools are required (cron for example).

This is the PL/Doc documentation of the PL/SQL packages the make up the product. Use the links in the left pane to view the package documentation.

See the examples document for various examples/tutorials.

Click here to return to the Tascha website.

To Do List

1. put db name in subject and body of success/fail emails.
2. cater properly for overloaded procedures. Currently just take first as correct one (need to prescan prms finding which overload is applivable).
3. Add methods for changing logging prms (debug, info, error)
4. Poss Allow logger to write to files as well as table.
5. document somewhere that booleans are unsupported because dbms_sql can't handle them
6. maybe make it so any expression (say to_chars on dates or date expressions) can come in as a prm to task
7. maybe allow sched_seconds column. when schedule job - submit as sysdate+(# secs)