Post reply

xp_sqlagent_enum_jobs

  • September 5, 2008 at 1:57 pm

    #212256

    Does it take awhile for a new job to show up in this extended proc? I'm working on a job activity monitor procedure/report, and when setting up a brand new job and running it, it does not show up here. I'm wondering why ...

    If anyone has any information, that would be great.

    Thanks

  • September 8, 2008 at 9:25 am

    #868518

    Another oddity found ... joining the job_id from [xp_sqlagent_enum_jobs] to msdb.dbo.sysjobs results in some not matching up ... can't figure out why yet. About 90% or so of my entire environment works just fine, but a handful between 2000 and 2005 do not match.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply