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).

The utility also logs all actions and provides public interfaces to the logging so your own custom procedures can write to the same logs and be emailed upon success and/or failure where necessary.

See simple help document for examples.

To Do List

1. TEST --- Allow DOW to be MON, TUE, MON-TUE etc as well as D of to_char.
2. Perhaps change logging funcs so do not receive sched_id, run_no. Just retrieve values from G_this_sched_id and G_this_run_no instead. Make spec simpler.
3. Procedure to allow task to be modified
4. Make it so any expression (say to_chars on dates) can come in as a prm to task
5. TEST --- DOW first & last work
6. Allow logger to write to files rather than table.