Auditing Triggers
$100-500 USD
Paid on delivery
I am working with an IT Automation software that schedules batch processing. It allows you to define Batch Jobs and the parameters required to get them to run at pre-determined times in some pre-determined order. Each of these batch "Jobs" are stored in a database. There are about 27 tables that make up each jobs definition. They are all tied together by:
**PK,FK1 TABLE_ID float**
**PK,I1 JOB_ID float
**Daily these definitions are copied into an active section of the database (a different set of tables) where they run. This allows users to change todays version but not the normal schedule.
I need to track any and all changes made to these "Jobs".
I need a trigger that will watch the tables that make up a job and when a change is found, it must write out the following information:
Date
Time
User making the change (This may be the result of a query against another table as there is only one product ID at the DB level)
Field Changed
Old Value
New Value
I need each of these changes written out to a table I can report out of.
## Deliverables
Deliverables:
4 Database Triggers (multiple if needed to run at the table level instead of the DB level) - 2 (or more) for Oracle and 2 (ore more) for SQL Server. The database schema is the same for both DB types but since the product can run under SQL as well as Oracle, I need to track both.
These triggers must be fully tested. I can provide database dumps/backups for testing.
I am including a zip with 2 DB schemas.
1 Trigger will go against the CEM612-DB Poster. For this one, I am interested in the purple Job Definitions Tables.
The other Trigger will go against the CTM610-DB-poster. This one goes against the Green Active Jobs tables.
Both Triggers can write out to a new table created in the same database as the chages are found.
## Platform
This is a request for DB Triggers. I need the same triggers for both MS-SQL 2000 and Oracle 9i.
Project ID: #3697410
About the project
Awarded to:
