1. UNIFYNow Forum
  2. Questions
0
Answered

Run T-SQL scripts

Matthew Woolnough 11 years ago • updated by anonymous 8 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.

Adam van Vliet 11 years ago

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.

Thanks.

Customer support service by UserEcho