470,866 Members | 1,862 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,866 developers. It's quick & easy.

Query SQL Servers

How can I query a SQL server to determine if an SQL job is enabled or not
using Visual Basic.net
Mar 1 '06 #1
2 937
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/20...TSCustTask.asp )


--
Regards, Vadym Stetsyak
www: http://vadmyst.blogspot.com
Mar 1 '06 #2
You can query the MSDB Database on the Server.

Select * From MSDB.dbo.SysJobs
Where Enabled = 1

HTH

Barry

Mar 1 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Steven Burn | last post: by
11 posts views Thread by Eugenio | last post: by
7 posts views Thread by Thomi Baechler | last post: by
2 posts views Thread by sqlgoogle | last post: by
1 post views Thread by Sean C. | last post: by
8 posts views Thread by VPaul | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.