Post reply

VB script for checking whether server is running or shutdown (in DTS package)

  • November 16, 2007 at 3:02 am

    #153966

    Hi Everybody,

    i wanna chek the opposite server status whether it is running or shutdown.

    this task i wanted to do thru DTS package(SQL 2000). for that i have choosen Activex scripting where i can place the VB script or Java Script to check the status of the server.

    according to my requirement if server is running DTS shud send successful msg. If not DTS shud send shutdown msg. Based on this task only i can do further.

    -arju

    Kindest Regards,

    arj

  • November 16, 2007 at 3:07 am

    #751757

    you can find the SQL Server status using SQL-DMO object, refer to SQL BOL.

  • November 16, 2007 at 3:14 am

    #751760

    Sorry hope i have not explained my problem clearly.

    i want to check the status of the server(at OS level). i dont want to check either SQL or any other.

    Only have to check whether opposite server is running or not(some time server may get shutdown unknowingly(not a production server) know. at that time my DTS shud send a mail saying that opp serve is down)

    Kindest Regards,

    arj

  • November 16, 2007 at 7:09 am

    #751828

    This is a duplicate post (I hate these!)... Check for the answer I gave on the other identical post...

    http://www.sqlservercentral.com/Forums/Topic422993-338-1.aspx

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply