Run T-SQL scripts

Matthew Woolnough 12 years ago updated by anonymous 9 years ago 1

It would be great for it to be able to schedule in T-SQL scripts when nothing else is running & delay run profiles when the T-SQL scripts are running. As a stretch target, recognising when various FIM & UNIFY dbs require reindexing & run appropriate scripts would be awesome.

Hi Matthew,

I believe EB-616 is quite similar to this issue. Periods of inactivity should be scheduled, as it provides a more predictable solution.

On the issue of recognising when a database required reindexing, this can now be done using a combination of EB31:Database Query Changes and EB31:Database Execute Query.