Re: jobs in sql server

From: Tom Moreau (tom@dont.spam.me.cips.ca)
Date: 12/27/02 

From: "Tom Moreau" <tom@dont.spam.me.cips.ca>
Date: Fri, 27 Dec 2002 10:17:18 -0500

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

Relevant Pages

  • Re: can you restore msdb to a new server?
    ... BooksOnLine has a section about resorting MSDB "msdb database, ... simple restore will give you the history etc as it was from the backup. ... > i've looked at all of those and none of them talk about moving system> databases to a new server that has the exact same name and ip as the old> server, ... >> http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles>> for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Periodic maintenance like sp_delete_backuphistory?
    ... Have a look at the sizes of your system databases. ... msdb on one of my servers ... Administrative Tools outside of SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Error 823 with msdb
    ... There is a way to rebuild msdb from scratch. ... Try this on a test server before doing this on a production server ... Start SQL Server from the command prompt recover just the master ...
    (microsoft.public.sqlserver.server)
  • Re: Cannot change installation path sql2005 (final release)
    ... I moved msdb and tempdb on my server and got this .NET Runtime message:- ... Unable to open shim database version registry key - v2.0.50727.00000 ... > Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.setup)
  • Re: Saving SSIS Packages
    ... I tried using the import wizard, importing a file based package and migrating ... Is DTC required for importing into msdb? ... When using the import wizard in SQL Server Management Studio, ... Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, ...
    (microsoft.public.sqlserver.dts)