To stop TM1 server from my local machine

Post Reply
mincharug.shulft
Regular Participant
Posts: 155
Joined: Fri May 20, 2011 8:17 am
OLAP Product: Applix,Cognos TM!
Version: applix9.0Cognos tm1 9.5.1
Excel Version: Excel 2010 2007

To stop TM1 server from my local machine

Post by mincharug.shulft »

HI All,

Tm1 is running under one server and i am working with client in my local PC and
i feel i want to stop the TM1 server from my local machine SO to do this
what command's can we use to stop them ? or this kind of logic's can we impletement it?

Please advice.?
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: To stop TM1 server from my local machine

Post by Duncan P »

Have a look at the AT command in Windows or the SCHTASKS.EXE which appears to be more flexible. Both of these set up a scheduled task but can do it on a remote computer. You could set up a task to run NET STOP command on the TM1 service perhaps.

[EDIT] Alternatively take a look at this, from the creator of Microsoft's SysInternals tools http://technet.microsoft.com/en-us/sysi ... s/bb897553. I've not tried it but it looks useful. Of course the ability to do this kind of thing is going to rely on rights that your network admin might be a little wary of allowing.
asutcliffe
Regular Participant
Posts: 164
Joined: Tue May 04, 2010 10:49 am
OLAP Product: Cognos TM1
Version: 9.4.1 - 10.1
Excel Version: 2003 and 2007

Re: To stop TM1 server from my local machine

Post by asutcliffe »

If you just want to start or stop the service remotely, you can use SC. This can be particular useful when TM1 has consumed all available RAM meaning logging on via remote desktop is incredibly slow.

http://ss64.com/nt/sc.html

You need to run it as an account with sufficient rights to stop the service on the target server though.

Another thing I've tried in the past is to create a script on the server to recycle the service and then call this from a TI process.This enables you to give people the ability to restart the service without giving them any extra access to the server itself. I haven't used it often but seems to work OK when I've tried it.

I hope that helps.

edit: all this assumes your server is running windows of course.
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: To stop TM1 server from my local machine

Post by lotsaram »

For shutting down or restarting a service with net stop and net start commands I use the MS ps tools utility linked to by Duncan which allows you to remotely execute a batch script on another machine. But should you need to do more than shut down a service remotely and reboot a server itself then it's even simpler, I have always used this very simple batch script.

Code: Select all

shutdown /r /f /m \\<your physical server name here> /t 003
(restarts remote server with time delay of 3 seconds. Very handy if server has become "locked up" and isn't accepting rdp connections.)
mincharug.shulft
Regular Participant
Posts: 155
Joined: Fri May 20, 2011 8:17 am
OLAP Product: Applix,Cognos TM!
Version: applix9.0Cognos tm1 9.5.1
Excel Version: Excel 2010 2007

Re: To stop TM1 server from my local machine

Post by mincharug.shulft »

i want it to stop the TM1 server from services which is running under server (2003 server) from my local PC .

please tell me what script can write to this?
asutcliffe
Regular Participant
Posts: 164
Joined: Tue May 04, 2010 10:49 am
OLAP Product: Cognos TM1
Version: 9.4.1 - 10.1
Excel Version: 2003 and 2007

Re: To stop TM1 server from my local machine

Post by asutcliffe »

mincharug.shulft wrote:i want it to stop the TM1 server from services which is running under server (2003 server) from my local PC .

please tell me what script can write to this?
As I've suggested, one way to achieve this would be:

Code: Select all

sc \\server_name stop service_name
Where server_name is the name (or IP address) of your win 2003 server and service_name is the name of the service that TM1 is running as.
Post Reply