473,327 Members | 1,919 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

connect to sql job agent

Is there a way to connect to SQL server and read all of the jobs listed in the job agent and get the status of each job?
I want to create either a web page or a winForm, have a list of all SQL DB servers in a drop down, select the db name, then show a list of all the jobs in the job agent and show the status of each job, (failed, running, succeeded, etc) and the last time the job ran and by who.

is this possible to do and if so how can i get started with something like this?
Aug 6 '07 #1
2 1864
Steve,

What version of SQL Server are you using? If you are using SQL Server
2005, you can take a look at SQL Server Management objects:

http://technet.microsoft.com/en-us/l.../ms162169.aspx

You should be able to get job information from these.

If you are using SQL Server 2000, then you can use SQL Distributed
Management Objects:

http://technet.microsoft.com/en-us/l.../ms131540.aspx

SQL DMO objects are COM objects, so you will have to access them through
COM interop.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Steve" <St***@community.nospam.comwrote in message
news:OJ**************@TK2MSFTNGP06.phx.gbl...
Is there a way to connect to SQL server and read all of the jobs listed in
the job agent and get the status of each job?
I want to create either a web page or a winForm, have a list of all SQL DB
servers in a drop down, select the db name, then show a list of all the jobs
in the job agent and show the status of each job, (failed, running,
succeeded, etc) and the last time the job ran and by who.

is this possible to do and if so how can i get started with something like
this?
Aug 6 '07 #2
I'm using SQL 05, I'll take a look, thanks
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.comwrote in
message news:%2****************@TK2MSFTNGP05.phx.gbl...
Steve,

What version of SQL Server are you using? If you are using SQL Server
2005, you can take a look at SQL Server Management objects:

http://technet.microsoft.com/en-us/l.../ms162169.aspx

You should be able to get job information from these.

If you are using SQL Server 2000, then you can use SQL Distributed
Management Objects:

http://technet.microsoft.com/en-us/l.../ms131540.aspx

SQL DMO objects are COM objects, so you will have to access them
through COM interop.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Steve" <St***@community.nospam.comwrote in message
news:OJ**************@TK2MSFTNGP06.phx.gbl...
Is there a way to connect to SQL server and read all of the jobs listed in
the job agent and get the status of each job?
I want to create either a web page or a winForm, have a list of all SQL
DB servers in a drop down, select the db name, then show a list of all the
jobs in the job agent and show the status of each job, (failed, running,
succeeded, etc) and the last time the job ran and by who.

is this possible to do and if so how can i get started with something like
this?

Aug 7 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

60
by: Fotios | last post by:
Hi guys, I have put together a flexible client-side user agent detector (written in js). I thought that some of you may find it useful. Code is here: http://fotios.cc/software/ua_detect.htm ...
4
by: Wonderinguy | last post by:
Our websphere application uses a generic application userid to connect and query db2 on z/os via DB2 connect. The end user,logs in to the application using his regular userid, which is then...
1
by: global | last post by:
We have a Linux Server with UDB-EE 8.1.5, which is used as gateway for client connections to zOS-UDB. Our question : How many memory on the gateway does every connect user need ? We intend to...
0
by: JenU | last post by:
Hi! Running DB2 Connect EE 8.1 on Windows 2000. When we execute a web app with a small amount of data returned, we do not have a problem. But, when we widen the criteria, we get errors... web...
27
by: Mike MacSween | last post by:
Some of my users are getting 'Disk or Network Errors'. I've raised it with the network admins, they're looking into it. In the meantime... My 'standard' error handlers logs errors to a table...
11
by: Mikael Arhelger | last post by:
Hello, This has been posted a few times but still I could not find a way to connect to our database. We run DB2 Express on WIN2K server with XP clients. I can ping inside network and to the...
0
by: =?Utf-8?B?TWlrZTEz?= | last post by:
Sorry for the cross post from dontnet.framework but I'm hoping this may see more activity here. I have written an application to access a web service. The application runs at multiple sites and...
0
by: =?Utf-8?B?TWlrZTEz?= | last post by:
Sorry for the cross post; I'm hoping this will get a response here... I have written an application to access a web service. The application runs at multiple sites and must cross a proxy server....
2
by: zgh1970 | last post by:
Hi, All, I have question on DB2 CONNECT configure. We installed DB2 ESE V8 FixPak 14 o AIX . When we set up the connection to DB2 Mainframe. We just catalog node and DB directory without DCS....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.