July 11, 2002 at 4:33 am
I was just asked if I knew what the Runnable column refers to in the Enterprise Manager Jobs window and I don't! - surprisingly, I'd never noticed it before. It is "Yes" for all my jobs, which are a varied bunch. BOL has two entries, both of which are irrelevant, and the SysJobxxx tables I looked at in MSDB don't have the column. Has anyone got a job which is not runnable, so I can know what the property refers to?
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
July 11, 2002 at 5:21 am
You're right, this column does seem a mystery with nothing in BOL (all my jobs are set to 'Yes'). I ran profiler against the population of the jobs screen, it calls msdb..sp_help_job which calls msdb..sp_get_composite_job_info which calls master..xp_sqlagent_enum_jobs. The resultset from this extended SP contains the fields [Running] and [Requested To Run] I don't know if any of these are the source??????
Regards,
Andy Jones
.
July 11, 2002 at 5:45 am
Thanks Steve - using the profiler didn't occur to me. Searched for 'xp_sqlagent_enum_jobs' and 'runnable' on Google which returned two hits - both no good and looking in BOL at 'sp_help_job' doesn't mention runnable as a return field in the recordset.
So, I guess we're stumped on this one.
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
July 11, 2002 at 6:17 am
Related to jobs on target servers maybe?
Andy
July 11, 2002 at 6:37 am
I believe Andy is right, but there is no real documentation on this field anywhere but I do seem to recall something like that.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 11, 2002 at 9:30 am
Thanks guys, this is sounding like it may be it. I haven't got the hardware here to set up multi-server jobs, so if anyone already uses them, could you let me know.
Cheers.
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply