Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Feb 2011
    Posts
    103
    Thanks
    1
    Thanked 1 Time in 1 Post

    Question 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

  2. #2
    Moderator chad_small's Avatar
    Join Date
    Dec 2002
    Location
    Gilbert, AZ
    Posts
    2,194
    Thanks
    1
    Thanked 26 Times in 25 Posts

    Default

    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.
    Chad Small
    IBM Certified Deployment Professional
    chadsmal@gmail.com
    http://www.tsmadmin.com

  3. #3
    Member
    Join Date
    Feb 2011
    Posts
    103
    Thanks
    1
    Thanked 1 Time in 1 Post

    Default

    Understood.
    Thanks for the help.

Similar Threads

  1. SQL Select command - Last status for each SQL Database?
    By jcpatum in forum Microsoft SQL Server
    Replies: 4
    Last Post: 03-26-2009, 06:40 PM
  2. Select statement through Administrative Command Line
    By scottgassTSM in forum Scripting
    Replies: 9
    Last Post: 04-07-2008, 10:10 AM
  3. Command line SQL query TSM
    By snapbean in forum Scripting
    Replies: 2
    Last Post: 02-19-2008, 05:42 AM
  4. sql select and blank line in output?
    By Stephan in forum Scripting
    Replies: 0
    Last Post: 01-17-2007, 01:24 PM
  5. SELECT from command-line not working as inside client
    By odyssey in forum Administrative Client
    Replies: 0
    Last Post: 10-26-2006, 05:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •