Is it possible to set the priority of data manager packages, for example, if we have multiple scheduled data manager packages running on a server in different appsets. all of the packages are scheduled to run at different time intervals, but unfortunately due to the nature of the processes, they overlap and cause contention issues on the servers.
Would it be possible to set the priority level of packages, for example package A is highest priority and hence will always take priority, even if package B is running.
is this possible through SQL server or Integration services?
The packages being run are standard BPC packages, for example Import, Admin_Optimize (Lite), certain packages are SQL based, meaning that they execute SQL Stored procedures to export data to other systems (R3, BW, etc)
Kind Regards and Thanks