Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

T-SQL for SQL Agent job details

Posted on 2012-03-29
1
Medium Priority
?
583 Views
Last Modified: 2012-04-10
Hi,
I am having difficulty looking at SQL agent job activity monitor at SSMS.

I am looking for set of TSQL well formatted scripts which will pull out details about jobs,status,execution times & other attributes from MSDB/DMV(storage for agent jobs)

Thanks
0
Comment
Question by:crazywolf2010
1 Comment
 
LVL 43

Accepted Solution

by:
Eugene Z earned 2000 total points
ID: 37784673
check code ready to use from

Querying SQL Server Agent Job Information
http://www.mssqltips.com/sqlservertip/2561/querying-sql-server-agent-job-information/
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question