>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?