how to view the job in text in sql server 2005

Question

hi,

Ex: for store procedure we use sp_helptext .is there any keyword for viewing jobs in text in sql server 2005

regards kumar

Answer 1

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.

Answer 2

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