SQL SERVER - Retrieve Information of SQL Server Agent Jobs « Journey to SQL Authority with Pinal Dave

Feed on: Posts; Comments

SQL SERVER - Retrieve Information of SQL Server Agent Jobs

May 31, 2007 by pinaldave

sp_help_job returns information about jobs that are used by SQLServerAgent service to perform automated activities in SQL Server. When executed sp_help_job procedure with no parameters to return the information for all of the jobs currently defined in the msdb database.

EXEC MSDB.DBO.sp_HELP_JOB

Reference : BOL

Posted in SQL, SQL Authority, SQL Cursor, SQL Documentation, SQL Download, SQL Error Messages, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, T SQL, Technology | 1 Comment

One Response to “SQL SERVER - Retrieve Information of SQL Server Agent Jobs”

on June 8, 2007 at 2:40 pm Wilson

Sorry Sir,

I dont have any idea about the SQL Server Agent Jobs… So please expain me what it is? and where it is used ?
with example…

Regards

Wilson Gunanithi . J

Trackback URI | Comments RSS

Leave a Reply

About Pinal Dave

Pinalkumar Dave is Microsoft SQL Server MVP and author of over 800 SQL Server articles. He has six years experience as Principal Database Administrator in MS SQL Server 2008/2005, .NET (C#) and ColdFusion MX. He has a Masters of Science degree in Computer Networks, along with MCDBA, MCAD(.NET) and ColdFusion Advanced MX Certifications.

MVP Profile
Blog Stats
- 5,739,964 Readers
SQLAuthority Links

My Homepage
My Resume
My Other Blog
SQL Server Mag Articles
--------------------
SQLAuthority
Best Articles
Favorite Articles
SQL Script Bank
Top Downloads
--------------------
SQL Interview Q & A
SQL Coding Standards
SQL FAQ Download
--------------------
SQL Random Article
Search SQLAuthority
Subscribe Email Update
SQLAuthority Feed
Translate SQLAuthority
--------------------
Jobs @ SQLAuthority

Find Your IP
Categories
- About Me (41)
- Best Practices (48)
- Data Warehousing (26)
- Database (242)
- DBA (202)
- Main (67)
- MVP (38)
- Pinal Dave (545)
- Software Development (73)
- SQL (826)
- SQL Add-On (77)
- SQL Authority (826)
- SQL Backup and Restore (50)
- SQL Coding Standards (84)
- SQL Constraint and Keys (46)
- SQL Cursor (63)
- SQL Data Storage (19)
- SQL DateTime (35)
- SQL Documentation (293)
- SQL Download (430)
- SQL Error Messages (361)
- SQL Function (96)
- SQL Humor (21)
- SQL Index (68)
- SQL Interview Questions and Answers (63)
- SQL Joins (356)
- SQL Performance (413)
- SQL Puzzle (10)
- SQL Query (826)
- SQL Scripts (530)
- SQL Security (368)
- SQL Server (826)
- SQL Server DBCC (254)
- SQL Stored Procedure (133)
- SQL Tips and Tricks (826)
- SQL Trigger (40)
- SQL User Group (16)
- SQL Utility (62)
- SQLAuthority (17)
- SQLAuthority Author Visit (38)
- SQLAuthority Book Review (29)
- SQLAuthority News (170)
- SQLAuthority Website Review (18)
- T SQL (826)
- Technology (826)
Top Posts
Recent Posts
Recent Comments
Archives
May 2007

M T W T F S S

« Apr Jun »

1 2 3 4 5 6

7 8 9 10 11 12 13

14 15 16 17 18 19 20

21 22 23 24 25 26 27

28 29 30 31
Pages
Latest Articles
- pinaldave
Click Cloud
About Me Best Practices Database Data Warehousing DBA Main MVP Pinal Dave Software Development SQL SQL Add-On SQL Authority SQLAuthority SQLAuthority Author Visit SQLAuthority Book Review SQLAuthority News SQLAuthority Website Review SQL Backup and Restore SQL Coding Standards SQL Constraint and Keys SQL Cursor SQL Data Storage SQL DateTime SQL Documentation SQL Download SQL Error Messages SQL Function SQL Humor SQL Index SQL Interview Questions and Answers SQL Joins SQL Performance SQL Puzzle SQL Query SQL Scripts SQL Security SQL Server SQL Server DBCC SQL Stored Procedure SQL Tips and Tricks SQL Trigger SQL User Group SQL Utility Technology T SQL