June 27, 2011 at 11:08 am
We have SQL 2000 Jobs that run when triggered from an ERP system. The jobs were created by sa or another administrator, and are run by sa or another administrator, but they were actually triggered by another user from the ERP system. Using the sysjobs and sysjobshistory we can see the administrators that created and ran the jobs, but we can't see the users that actually triggered the jobs.
My question is this: Is it possible to track the users who actually triggered these jobs?
If you need any more information, please let me know.
Steve
June 27, 2011 at 11:16 am
As with many database things.. It depends.
Usually the history of a job will show who started it. The problem I have seen is that from ERP servers (and other types too) they have a single user that is actually used to start the job, so from the database side, if thats how you have things setup, then I can say almost certainly NO. Your ERP system very likely has a log of it though indicating who requested the job start.
CEWII
June 27, 2011 at 12:26 pm
Elloitt,
You are absolutely right. The ERP jobs run through the one administrator user. I did some checking, and I will indeed be able to find the user in the ERP database. Thank you very much.
Steve
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply