B_gd_n[ ]Sahlean:

O posibilă soluţie in VB6 cu DMO (efortul de adaptare e minim pentru VB[.NET] şi SMO):
Dim serverSql As New SQLServer

serverSql.LoginTimeout = 30
serverSql.Name = "server\instantaSQL"
serverSql.Login = "sa"
serverSql.Password = "parola pestelui prajit"
serverSql.Connect

MsgBox serverSql.JobServer.Status, , "Daca Status=1 atunci este Running"

Bogdan,

Am incercat si eu cu serverSql.JobServer.STATE ..., nu STATUS

 
Dar din pacate STATE este de tipul   SqlSmoState http://technet.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.sqlsmostate(SQL.100).aspx

Creating	The object is being created.
Dropped	The object is being dropped.
Existing	The object exists.
Pending	The object is pending an instruction.
ToBeDropped	The object is waiting to be dropped.

Iar STATUS nu exista la adresa

http://technet.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.agent.jobserver_properties(SQL.100).aspx

Tu ai incercat ce ai zis cu STATUS ?

---

Ignat Andrei
http://serviciipeweb.ro/iafblog