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 Programming
 How can i get all sqljob names in my server

Author  Topic 

boreddy
Posting Yak Master

172 Posts

Posted - 2009-07-08 : 07:58:14
How can i get all sqljobs in my server
plese help me


thanks in advance

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-07-08 : 08:20:51
select name from msdb..sysjobs
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-07-08 : 10:26:08
or

EXEC msdb..sp_help_job

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -