Welcome to Sign in | Help

Re: cum pot afla daca sql server agent ruleaza ?

  •  05-14-2008, 5:55 AM

    Re: cum pot afla daca sql server agent ruleaza ?

    Cryogenic1981:
    uite un ex folosind C# 3.0 pt SQL 2000 si 2005. Merge cu si oricare alta versiune precedenta daca-l scrii cu foreach. Trebuie sa adaugi o referinta spre System.ServiceProcess.

    using System;
    using System.Linq;
    using System.ServiceProcess;
    class Program
    {
        static void Main(string[] args)
        {
            foreach (var service in ServiceController.GetServices().Where( sc => (sc.ServiceName.StartsWith("SQLAgent") || sc.ServiceName.StartsWith("SQLSERVERAGENT")))) {
                Console.WriteLine(String.Format("SQL Agent: {0} Running: {1}", service.ServiceName, service.Status == ServiceControllerStatus.Running ? "Yes": "No"));
            }
        }
    }

    Super codul ...dar ... ai putea sa imi spui , ca la Power Shell, cum fac diferentele intre diferitele instante ?

    Ignat Andrei
    http://serviciipeweb.ro/iafblog
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems