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 ?

Thanks

Nick