Download
Tascha is available for download as either a ".zip" file or ".tar.gz" file.
The contents are identical - just trying to make it easier for you to get
the files where you want them.
The latest version is here
For details of system requirements please see the installation section.
No investigation into licencing has been done but needless to say the
scripts are provided 'as is' for you to use as you see fit. There is no
guarantee that these scripts will work - please use caution at all times.
Tascha has been lovingly crafted and every effort will be made to help
you out with problems and improve it where necessary but, at the end of
the day, if you use it to make a mess of something - you are on your own.
Latest Version
Significant changes in this version are (part done version - may change):
- Added new option to allow capture of session wait statistics from scheduled task run. Data is visible through a view and can be used to diagnose unexpectedly long runs.
- Allowed date ranges to wrap around the end of the week - for example FRI-TUE becomes FRI, SAT, SUN, MON, TUE.
Old Versions
Significant changes in this version are:
- 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 so it can be used in custom applications.
- Included auto-installed task to check that Tascha hearbeat is not skipping minutes. See release notes for caveats.
Significant changes in this version are:
- Added change_task procedure to change attributes of a task.
- 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 tascha 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.
Significant changes in this version are:
- DB name now appended to email subject of success/failure emails to help in multi
instance environments.
- Fixed bug that raised exception when calling procedures with no parameters.
- 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.
Significant changes in this version are:
- Changed default schema from xxtascha to tascha.
- Added admin procedures to drop tasks and schedules.
- Fixed bug when checking if day of month is first/last of the month.
- Introduced run_stats option against schedule to log session statistics after task completion.
Significant changes in this version are:
- 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 the Tascha log from their procedures.
- 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 a task to analyze the Tascha schema with the install. A wrapper for
dbms_stats.gather_schema_stats is used as booleans are not supported by dbms_sql.
- 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.
Significant changes in this version are:
- Changed logging procedures to cache logs to arrays and flush on request (60% performance boost for logging)
- Included topqueries example task and request code
- Added option for DOW to be MON, TUE, etc rather than just 1, 2, etc
- Included maintenance task to tidy logging table
Significant changes in this version are:
- Initial version made available.
