Post reply

sp_help_job* system stored procedures (MS SQL2K)

  • February 3, 2004 at 9:20 am

    #108856

    I am trying to capture scheduled job information in an automated fashion, vs. using SQL EM GUI to manually check this, and found the following system sprocs that would foot the bill:

    sp_help_job

    sp_help_jobhistory

    sp_help_jobschedule

    sp_help_jobserver

    The problem is , these objects dont exist in my master db.

    They are referenced in my SQL BOL, though. Does this mean, my BOL is a more recent version , and thus, contains references to these objects that dont exist in my db? If so, are newer db objects, eg, sp_* and xp_*, included in any SQL updates? Do I need to find these scripts somewhere and build them into my master db?

    My other option is to "reinvent the wheel" and build similar sprocs myself that would capture this information for the system tables, but I would like to avoid that.

    Thanks

  • February 3, 2004 at 9:46 am

    #492635

    They're in msdb as that's where the jobs are, not master. 



    --Jonathan

  • February 3, 2004 at 9:58 am

    #492644

    Jonathon - Thanks for the quick reply.

    I just put a profile on my server, then created a job in SQL EM , and sure enough, I saw that the scheduler was calling the sprocs i couldnt locate, BUT, not from master, but msdb db.

    Thanks though for your response

    Greg

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

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