asked on

views that a system proc calls

sometimes a system proc calls many tables/views

example:
exec msdb..sp_help_job @job_name= 'jobname'

return 4 result sets. would they always relate to 4 different system views, necessarily?

then we can query that particular one alone.. or insert into temp table etc

Thanks

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Raja Jegan R

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anushahanna

ASKER

OK. Thanks.

I need to compile a list of all the steps in each jobs and which database they use.

so the second result set is of interest to me - StepName and DatabaseName. If I can just get that system viewname,
then I go straight to it.

SOLUTION

Valliappan AN

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Raja Jegan R

>> I need to compile a list of all the steps in each jobs and which database they use.

I suppose, the simpler way would be to script out the job and then anaylze it completely. Because in some cases, a particular step in a job might be scheduled to run across all databases.

Hope I answered in sync with your question. Else kindly give me more inputs.

SOLUTION

Scott Pletcher

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anushahanna

ASKER

Thanks - helped indeed.