how to view the job in text in sql server 2005

Ex: for store procedure we use 开发者_如何学Pythonsp_helptext .is there any keyword for viewing jobs in text in sql server 2005

regards kumar

You can query the various tables in msdb database to get the list of the jobs and their details.

For example

select * from msbdb.dbo.sysjobs

will give you the list of all the jobs in the server while

select * from msdb.dbo.sysjobactivity 

will give you the job activity details.

For stuff like this where I know how to do something in Management Studio but aren't sure of the way to do it by code I sometimes start a profiler trace then perform the action in Management Studio to see what that is doing. Doing that on my system indicates that the following might help.

exec msdb.dbo.sp_help_jobstep @job_name = 'Your job name'

If you look at the definition of that it seems to use msdb.dbo.sysjobsteps