Is It Possible to view SQL Submitted by Reporting Facility

A lot of scripts ans example to extract information from Control-M tools.
Post Reply
User avatar
DocGoo
Nouveau
Nouveau
Posts: 73
Joined: 08 Sep 2010 12:00

Is It Possible to view SQL Submitted by Reporting Facility

Post by DocGoo » 22 Oct 2012 7:57

The problem is to see what table(s) the reports generated in Reporting Facility are accessing. Most helpful would be to view the SQL RF submitts to the SQL Server. The Summary view during report generation does not seem to contain this.

Thank you!!!!

Goo

User avatar
mauriziog
Nouveau
Nouveau
Posts: 807
Joined: 08 Jun 2007 12:00
Location: Varese - Italy
Contact:

Post by mauriziog » 26 Oct 2012 11:52

You can:
- use the definitions field like:
description, docmem, doclib, etc. to identify the SqlJobs

- if you use the CM for DB use the accounts to define DB type or machine/user and the fileName to identify tables or others informations.

- If you use scripts or embeddedScripts the names of the scripts can identify some informations.

- If you have few parametrized scripts, you can put the variables informations in description.

Is a naming convention that is always usefull, for reports but also for day-to-day manitoring and control; and also to control nember of connections on one DB, read and write operations, and so on.

Post Reply