>>Hi
>>
>>I've got several scheduled tasks running on the job agent in SQL Server that update files in 3rd party database.
>>
>>The trigger on some of the tables sets updated by to SUSER_NAME(). I can't later these triggers
>>
>>I want make the updated_by reflect which job was running and updated a row.
>>
>>Any ideas on the best way to do this ?
>>
>
>Do you mean, the actual name of the job....or the service account associated with Agent?

Either really Kevin . Or whichever is easiest at the moment all the jobs are associated with sa