Skip to main content
SUBMITTED

User that launch a package or job

  • June 27, 2023
  • 3 replies
  • 41 views

rvgfox
Problem Solver
Forum|alt.badge.img+4

In our current environment we have several developers.

We have scheduled jobs that launch run packages, but we can manually launch jobs or run packages.

Is it possible to know which user is launching the process?

 

3 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8
  • TimeXtender Xpert
  • June 28, 2023

If you are talking about 20.10.x and connecting to your repository / databases using Windows / Azure AD authentication, you should be able to see the user running commands against the database from SQL Server (i.e. sp_who2 or sp_whoisactive if you have that installed). The repository gives you the processIDs which can also be matched to users from Taskmanager / Procmon.

 

If you use SQL Server authentication, you are sharing the same credentials across services and users so there isn't an easy way to see from the database end.

For the new release the API doesn't seem to return such info and I don't think it is shown in the UI or the portal anywhere (yet).

 

 


rvgfox
Problem Solver
Forum|alt.badge.img+4
  • Author
  • Problem Solver
  • June 29, 2023

Yes I’m talking about the new version. Is it possible on that?


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

It is currently not possible to extract this data in the new version. I will convert this question to an idea.