Re: jobs in sql server
From: Diana M (DianaM@NOJunk.com)
Date: 12/27/02
- Next message: Josh: "Retrieve the IP Address from a Failed Login Attempt"
- Previous message: Tom Moreau: "Re: jobs in sql server"
- In reply to: Tom Moreau: "Re: jobs in sql server"
- Next in thread: Diana M: "Thanks! It worked"
- Reply: Diana M: "Thanks! It worked"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Diana M" <DianaM@NOJunk.com> Date: Fri, 27 Dec 2002 07:47:27 -0800
I meant we have 2 separate jobs. It is same name and it
runs same SP, but it is 2 separate jobs.
Yes, I have added the user to db_owner role in msdb and
he still can not see the job on production server.
This user is not a member of sysadmin role. Actually I do
not want to give sysadmin rights to him, because he does
not need it. His rights are limited to access to the
single database on the server and he needs to run this job.
>-----Original Message-----
>Some possibilities come to mind. Has the user been added
to the db_owner role in msdb on the dev box? Has he/she
been added to the TargetServersRole role in msdb? Is this
user a member of a Windows group that has been added to
the sysadmin role?
>
>--
>Tom
>
>----------------------------------------------------------
-----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
> "Diana M" <DianaM@NoJunk.com> wrote in message
news:030b01c2adb5$bd108ee0$8af82ecf@TK2MSFTNGXA03...
> Hello everybody,
> We have 2 SQL Servers7. One is the development and
the
> other is production. Both servers has the same job X. I
> have Admin rights and I am the owner of the X job on
both
> servers.
> We have user USER1 on both servers who is not
> administrator.
> I am wondering if somebody could explain why USER1 can
> see the job X on development server, but he can not see
it
> on the production ????
>
> Thank you in advance
> Diana M
>
>
- Next message: Josh: "Retrieve the IP Address from a Failed Login Attempt"
- Previous message: Tom Moreau: "Re: jobs in sql server"
- In reply to: Tom Moreau: "Re: jobs in sql server"
- Next in thread: Diana M: "Thanks! It worked"
- Reply: Diana M: "Thanks! It worked"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
