You can stop and start data warehouse jobs that are running in service manager. for example, you might have to stop all of the data warehouse jobs that are running to ensure that a security update to the data warehouse management server does not interfere with any jobs that might run.. Use powershell on your data warehouse server. also, when the mpsync or dwmaintenance jobs start, they disable all of the etl jobs. you will see the is enabled column set to false for each of the etl jobs. this means that even if the etl job status shows it is running, it actually is not running.. The most common reason for a stuck data warehouse job is that the data warehouse management server lost communication with microsoft sql server. this occurs if sql server was updated without the service manager administrator's knowledge..
Step 3 � re-enable the cube processing jobs in scsm. after the script in step 2 has, run this powershell script on your service manager data warehouse management server to re-enable the cube processing jobs:. This post will aid in troubleshooting the following issues concerning the service manager data warehouse: � slow execution of etl jobs � etl jobs failing to complete � etl jobs failing to start. 1. troubleshooting � open a remote desktop session to the service manager management server � open the service manager management shell. With a user base of up to 7000 users the script should not take longer then roughly 45 minutes to complete including running the cube jobs. when this has occurred for me and i have verified there are no locks i usually reboot the data warehouse management server and the dw database, if you can, then rerun the scripts..
