This table has details of all operations in the Integration
Services catalog.
SELECT [operation_id]
,[operation_type]
,[created_time]
,[object_type]
,[object_id]
,[object_name]
,[status]
,[start_time]
,[end_time]
,[caller_sid]
,[caller_name]
,[process_id]
,[stopped_by_sid]
,[stopped_by_name]
,[operation_guid]
,[server_name]
,[machine_name]
FROM [SSISDB].[internal].[operations]
|
The type of object affected by the operation.
Object Type
The object type may be
10- Folder
20- Project
30 -package
40
-environment
50- Instance
of execution
Status
The status of the operation. The possible values
1-arecreated
2-running
3-canceled
4-failed
5-pending
6-ended
unexpectedly
7-succeeded
8-stopping
9-completed
Operation type
This view displays the following operation types, as listed
in the operation type column:
Operation Type
|
Operation Type description
|
1
|
Integration Services
|
2
|
Retention window (sql Agent
job)
|
3
|
Max project version(SQL
Agent Job)
|
101
|
Deploy Project
|
106
|
Restore project
|
200
|
Create execution and start
execution
|
202
|
Stop operation
|
300
|
Validated project
|
301
|
Validate package
|
1000
|
Configuration catalog
|
Created Date
In this column store when the package is executed.
Object ID
It is nothing but the package ID.
SELECT
p.name,*
FROM [SSISDB].[internal].[operations] o
INNER JOIN [SSISDB].[internal].packages p
ON p.package_id=o.object_id
order by 1
|
Start Time
When the package was stared.
End Time
When the package was completed.
We can find the time taken by the package with the help of
start and end time.
Caller name
How we call the package. The name of the account that performed the operation. I mean to
say we call the packages through sql server agent or manually or any third
party tool.
Server name
Where the packages are store.
Machine name
From where we execute the package.
I have executed on my pc so that it is showing same.
Note: If our server is
running shortage of space we can truncate this table. It will not affect our
operation. Here we are store only package executing details.
