SQL Agent Jobs Status - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

SQL Agent Jobs Status

Author

Topic

vvangala
Starting Member

1 Post

Posted - 2010-05-07 : 14:11:18

Hi,

Can you please help me in getting a report for getting the following information from SQL server 2005, I need

SQL Night Job Name

Stored Procedure(s) being called within the job

Last Execution Status

Thank You

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-05-07 : 14:58:28

What SQL Version you are using ?

Regards,
Bohra

I am here to learn from Masters and help new bees in learning.

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-05-07 : 15:07:46

Have a look at below link.. It gives fair idea on job names, status etc..

http://sql-articles.com/blogs/script-to-find-sql-job-activity-details/

Regards,
Bohra

I am here to learn from Masters and help new bees in learning.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources