Trigger on system tables

Lets say for example
If someone disable a job and forgot to inform other team members

If someone modify a package and save it in sql server but forgot to inform others
If someone add new job or modify schedule but forgot to inform other team members.
there are number of such scenarios....
In all this case if we can put a DML trigger on system tables like sysjobs,sysdtspackages which will fire a mail to other team members on data changes in this tables then I think we can better monitor our servers.

We can put triggers on this tables , but not sure in future hot packs or service packs this tables will be modified or not. so we are avoiding to put triggers on this tables.

If microsoft is supporting triggers on system tables then it will be definitely a great help for all of us and also can convince our clients also for this.

No comments:

Post a Comment

Popular Posts