Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-09 : 08:27:01
|
| Praveen writes "Hi,I have created a few DTS jobs, which are schedule by the user id - userId1, [Which is nothing but Windows Authentication user id].I have a stored procedures whichs runs to enable and disable these jobs.I am able to run this stored procedure and disable/enable the DTS jobs whenever I login with Windows Authentication as selected option.When I log in to the SQL server using other userid, say userId2, the stored procedure runs throwing error "job not found".I know that, since the jobs are scheduled using userId1, userId2 don't have access to the jobs. I want to know how can I give permissions to my DTS jobs to userId2, or any other alternatives for this.Thanks in advance.Regards,Praveen" |
|
|
KLang23
Posting Yak Master
115 Posts |
Posted - 2005-06-10 : 17:45:05
|
| HiMake the owner of the job (drop-down in Job Properties) an id or role common to both logins. Usually "SA" is the owner, but this may not work for you. Make the job independent of your particular Id common to the group of logins who need to execute it.I'm assuming the problem is related to the job subsystem and not DTS.Cheers. |
 |
|
|
|
|
|
SQL Server - DTS Jobs