Operations table in SSISDB

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.