Due to some security changes in my company, each server user must have his/her own database user (SQL Server Authentication). In the past, the authentication was provided by a windows user and we had to log in in the server (the machine) and start up Enterprise Manager, but now each of the members of my department has its own user and we need to monitor job's activity, but each time we want to referesh the jobs the status appears as not running
even if we are aware that they are running. I've read that setting the job owner works, but you can set just one user, not a group of users, and putting the users as sysadmin
is not an option. Any Ideas?
View Complete Post