script for getting all the server job details

SQLServerCentral is supported by Red Gate Software Ltd.

Home Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » script for getting all the server job details...

script for getting all the server job details

Rate Topic

Display Mode

Topic Options

Author

Message

rahul.soni2

Posted Friday, July 03, 2009 10:14 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, November 04, 2009 7:51 AM
Points: 4, Visits: 32

Hello I want a script which will give details about all the job present in the in the server. Please provide.

Post #747050

Lowell

Posted Friday, July 03, 2009 10:19 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 5:24 AM
Points: 3,414, Visits: 8,766

there is a scripts section here on SSC with literally thousands of script contributions.
you can use the search feature in the upper right corner of this page...
i used it to search for "script job details" and here's the first link:
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31739/

Lowell
help us help you! if your post doesnt have CREATE TABLE YOURTABLENAME and INSERT INTO YOURTABLE SQL statements, chances are you didn't post enough information for us to help you! If you can, avoid pseudocode and show us your actual query...it makes it much better for you to see a good example with your tablenames you'd understand, and be able to copy and paste for immediate testing.

Post #747052

« Prev Topic | Next Topic »

Permissions