ansaurus

Question

How to monitor SQL Server Agent Job info in C#

Answer 1

A:

This should be a good starting point to find out how to find your SQL Agent jobs using T-SQL:

View (and disable) SQL Agent Jobs with TSQL

The script will list out all your jobs on your database, and when they will be run next and so forth.

Using the job_name, you should also be able to find out details about your jobs using the SQL Server Agent Stored Procedures in the msdb database on your server.

marc_s 2010-09-21 05:21:40

Alternatively, take a look at this MSDN page http://msdn.microsoft.com/en-us/library/aa260604%28v=SQL.80%29.aspx - specifically the SQL Server Agent Tables.

Will A 2010-09-21 05:24:10

Answer 2

A:

You can get a list of all server jobs using this SELECT:

SELECT [name] FROM msdb.dbo.sysjobs

If you'd like to get a list of currently running jobs and their information, I would recommend writing a stored procedure in SQL which your application calls. There's a good demonstration here you could use...

http://feodorgeorgiev.com/blog/2010/03/how-to-query-currently-running-sql-server-agent-jobs/

Good luck!

timothyclifford 2010-09-21 05:34:42

If you post code or XML, **please** highlight those lines in the text editor and click on the "code" button (101 010) on the editor toolbar to nicely format and syntax highlight it!

marc_s 2010-09-21 06:54:57

thank for every suggestion ,Although i have a little confused because i am a really rookie but i will try to do follow every suggestion.

Fernatit 2010-09-21 08:08:35

ansaurus

tags:

views:

answers:

How to monitor SQL Server Agent Job info in C#

related questions