System Stored Procedures referring to which tables.??

• drvnswamyxtra

  Old Hand

  Points: 337

  More actions

  February 14, 2011 at 4:21 am

  #245462

  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.

• Satnam Singh

  Hall of Fame

  Points: 3542

  More actions

  February 14, 2011 at 4:27 am

  #1286378

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

  Cheers,

  Satnam

• Eralper

  SSCarpal Tunnel

  Points: 4438

  More actions

  February 14, 2011 at 5:10 am

  #1286404

  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.

  Eralper
  SQL Server and T-SQL Tutorials and Articles
  Microsoft Certification and Certification Exams