Version 1.4 (07-OCT-2005)
===========================================================================
Added new flag for a task schedule to state that output from v$session_event
should be stored after a task call. Enables a user to see if a task was held
up by any waits.

Added 2 new views (task_waits_v, task_stats_v) to allow viewing of task 
runtime informations to be granted easily

Removed stats from standard log as they can be viewed from their own tables,
see above.

Added new util script show_stats.sql to view wait/stat information.

Changed task_log_maint procedure to also tidy up task_stats and task_waits

Allow date ranges to wrap around weeks - for example FRI-TUE becomes FRI, SAT,
SUN, MON, TUE.

Version 1.3 (09-SEP-2005)
===========================================================================
Added drop_task_prm procedure to remove a parameter from a scheduled task

Fixed bug when adding runstats to task log

Added TSC category and used for auto installed tasks

Put check_scheduler in admin package header

Included auto-installed task to check that tascha hearbeat is not skipping minutes.
It will full scan task_log_lines but if run out of hours this should be fine.
Also this proc prevents admin package compiling under 8i - so needs commenting out
in this case.

Version 1.2 (20-JUL-2005)
===========================================================================
Add change_task procedure to change attributes of a task

Added utility script show_tasks to... show tasks!!!

Changed code to log stats into task_stats table rather than just append
to log. Also changed default setting for stats collection to Y as it's a
small overhead but could be really handy when something has gone awry.

Added extra parameter of I_ora_trace when scheduling tasks. This will enable
event 10046 for the duration of the task. It will override any setting of 
I_sql_trace. Disabling one disables both.

Changed utility scripts - show_sched.sql and show_logs.sql to use views. The
views make it easier for visibility of tacha data to be granted to other users.

Added ability to enter negative DOM parameters. For example "-1" would match
the last day of the month as it would wrap around.

Added logger_ctl procedure to tascha_pkg to enable/disable logging levels

Version 1.1 (29-JUN-2005)
===========================================================================
Fixed bug that raised exception when calling procedures with no parameters

DB name now appended to email subject of success/failure emails to help
in multi instance environments.

Fixed bug that raised exception when dropping a task with email parameters
present. Also raise_application_error when try to drop a non-existant task
or schedule.

Version 1.0 (06-MAY-2005)
===========================================================================
Changed default schema from xxtascha to tascha.

Added admin procedures to drop tasks and schedules.

Fixed bug when checking first/last DOM. Getting invalid date from
NEXT_DAY if TO_CHAR(SYSDATE,'D') returns '0'. Used 'DY' instead.

Changed taschx_pkg and tascha_pkg to use raise_application_error()
rather than packaged exceptions. User will see error then as they
are not likely to ever call procs inside exception block.

Added run_stats option against schedule to log session statistics after
task completion.


Version 0.9 (20-APR-2005)
===========================================================================
Changed logging to not require sched_id and run_no as parameters. These
are set through package variables instead when a task is called.

Added tascha_logger package so all users can be granted access to logging
procedures without having access to admin procedures. Makes things easier
for end users to write to tascha log from their procedures.

If no failure email address is specified then use admin address specified
at install instead.

Added title for schedule entries so sub titles can be specified. For example
the task may titled "Salary Report" but two different schedule entries could
be titled "Increases" and "Pending" to reflect variations caused by different
input parameters.

Added dbms_application_info calls so jobs can be viewed in v$session.

Included wrapper for dbms_stats.gather_schema_stats and included task to
analyze tascha schema. Wrapper for dbms_stats required as we cannot use
booleans - dbms_sql does not support them.

Split logging table into two. Header table task_logs and details table
task_log_lines. Added utils/show_logs and show_log scripts for easier
viewing of logs.

Version 0.8 (10-MAR-2005)
===========================================================================
Added logging to triggers on tasks, task_schedule to catch schedule changes

Included maintenance task for task_logs table.
Procedure task_log_maint. Task disabled as default.

Added option for DOW to be MON, TUE, etc rather than just 1, 2, etc.
These are converted to 1, 2 equivalents at run time using date format 'D'

Made reschedule_task raise an exception when invalid schedule id used.

Moved scripts into sub-directories to tidy up installation.

Included topqueries example.
topqueries.sql is procedure to be created as priveliged user.
topqueries_req.sql is pl/sql to create task as tascha admin user.

Changed logging procedures to cache logs to arrays and flush on request

Version 0.7 (20-FEB-2005)
===========================================================================
1st recorded version
