System Stored Procedures referring to which tables.??

  • Hi,,

    sp_help_job

    sp_help_jobcount

    sp_help_jobactivity

    sp_help_jobshistory

    sp_help_jobs_in_schedule

    sp_help_jobschedule

    I want to know, from which TABLES the above storedProcedures are being executed and fetching the data.

    Thank you.

  • U can execute sp_helptext stored procedure name in the msdb database and u will get the required information.

    Cheers,

    Satnam

  • Hello,

    These are objects from msdb database.

    If you go to MSDB system database and browse the system tables node, you will see a list of table whose names are starting with dbo.sysjob...

    You can check these tables for jobs, job steps, job schedules and job histories.

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

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