Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Job agent
Message
From
21/03/2014 12:19:59
 
 
To
21/03/2014 12:16:23
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Environment versions
SQL Server:
SQL Server 2008 R2
Application:
Desktop
Miscellaneous
Thread ID:
01597051
Message ID:
01597054
Views:
42
>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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform