Results 1 to 3 of 3
Thread: SQL Command Line (SELECT)
-
04-19-2011, 01:15 PM #1Member
- Join Date
- Feb 2011
- Posts
- 91
- Thanks
- 1
- Thanked 1 Time in 1 Post
SQL Command Line (SELECT)
Dear friends,
I wonder which command (SELECT) to see if the SCHEDULER server (client) is active (INSTALLED).
Without going into each server and check the SERVICES.MSC or ps-ef | grep tsm to check if the services are active (STARTED).
Thank you for your attention.
Ramon
-
04-19-2011, 06:29 PM #2
If the scheduler is running then the client should have shown a connection within the last day. To check if the scheduler is installed you can check the tcp address setting to see if the server has one listed. If so then the client has connected although it doesn't guarantee that the scheduler has been setup. Associating a schedule works to see if a scheduler is running/installed. If it fails then you know its not setup or running.
-
04-20-2011, 01:24 PM #3Member
- Join Date
- Feb 2011
- Posts
- 91
- Thanks
- 1
- Thanked 1 Time in 1 Post
Understood.
Thanks for the help.
Similar Threads
-
SQL Select command - Last status for each SQL Database?
By jcpatum in forum Microsoft SQL ServerReplies: 4Last Post: 03-26-2009, 06:40 PM -
Select statement through Administrative Command Line
By scottgassTSM in forum ScriptingReplies: 9Last Post: 04-07-2008, 10:10 AM -
Command line SQL query TSM
By snapbean in forum ScriptingReplies: 2Last Post: 02-19-2008, 05:42 AM -
sql select and blank line in output?
By Stephan in forum ScriptingReplies: 0Last Post: 01-17-2007, 01:24 PM -
SELECT from command-line not working as inside client
By odyssey in forum Administrative ClientReplies: 0Last Post: 10-26-2006, 05:10 AM


Reply With Quote
