Database Reference
In-Depth Information
Figure A-25 . Application Instance—in color!
I call this Operational Intelligence. An enterprise operations person can look at this
report and glean lots of information about the current state of enterprise data integra-
tion processes.
The Package Instance report is remarkably similar. Let's begin by adding the stored
procedure to the database, as shown in Listing A-23 .
Listing A-23 . Adding the rpt.ReturnPkgInstanceHeader Stored Procedure
/* rpt.ReturnPkgInstanceHeader stored procedure */
If Exists(Select s.name + '.' + p.name
From sys.procedures p
Join sys.schemas s
On s.schema_id = p.schema_id
Where s.name = 'rpt'
And p.name = 'ReturnPkgInstanceHeader')
begin
print 'Dropping rpt.ReturnPkgInstanceHeader stored
procedure'
Drop Procedure rpt.ReturnPkgInstanceHeader
print 'Rpt.ReturnPkgInstanceHeader stored procedure
dropped'
end
print 'Creating rpt.ReturnPkgInstanceHeader stored
procedure'
go
Create Procedure rpt.ReturnPkgInstanceHeader
@AppInstanceID int
 
 
 
Search WWH ::




Custom Search