G Guest Mar 1, 2006 #1 How can I query a SQL server to determine if an SQL job is enabled or not using Visual Basic.net
V Vadym Stetsyak Mar 1, 2006 #2 Hello, Paul! P> How can I query a SQL server to determine if an SQL job is enabled or P> not using Visual Basic.net Do you mean DTS job by "SQL job", if so then take a look at these links they may help you in understanding how can you access DTS from managed code ( http://www.15seconds.com/issue/030909.htm ) ( http://www.c-sharpcorner.com/Code/2003/Jan/DTSCustTask.asp ) -- Regards, Vadym Stetsyak www: http://vadmyst.blogspot.com
Hello, Paul! P> How can I query a SQL server to determine if an SQL job is enabled or P> not using Visual Basic.net Do you mean DTS job by "SQL job", if so then take a look at these links they may help you in understanding how can you access DTS from managed code ( http://www.15seconds.com/issue/030909.htm ) ( http://www.c-sharpcorner.com/Code/2003/Jan/DTSCustTask.asp ) -- Regards, Vadym Stetsyak www: http://vadmyst.blogspot.com
B Barry Mar 1, 2006 #3 You can query the MSDB Database on the Server. Select * From MSDB.dbo.SysJobs Where Enabled = 1 HTH Barry
You can query the MSDB Database on the Server. Select * From MSDB.dbo.SysJobs Where Enabled = 1 HTH Barry
