Jobs step can't see database

From: Fred K (fkilby@co.marin.ca.us)
Date: 12/30/02 

From: "Fred K" <fkilby@co.marin.ca.us>
Date: Mon, 30 Dec 2002 10:40:49 -0800

We have a situation where we want to give developers the ability to create
jobs to automate some process to run after hours. They can't run DTS
packages because the DTS jobs use CmdExec, which only SysAdmin's have the
privilege of.

Here is the problem. When the developer try's to create a job

1 - She selects new job from the right-click menu on jobs. This is fine.
2 - The New Job Properties box opens, she add Name, Category and
Description. The Owner edit box is grayed out and empty.
3 - She can move to the Steps tab
4 - She can click [New...] and the New Job Step window opens.
5 - She can add a Step Name, select a Type and enter a Command, but does not
see her Database. This is the problem.

When she clicks to list the Databases she only has listed:
- master
- msdb
- northwind
- pubs
- tempdb

but not her application database (AppDB). She has permissions as "dbo" for
her (AppDB) via group membership and herself.

Any ideas as to what might be wrong?

Thanks for any help in advance.

Fred

Relevant Pages

  • Re: Jobs step cant see database
    ... >We have a situation where we want to give developers the ability to create ... >packages because the DTS jobs use CmdExec, ... >but not her application database (AppDB). ...
    (microsoft.public.sqlserver.security)
  • Re: Datebase needed for tracking of drugs for a fire department!
    ... including for MS Access database development. ... There are good developers, don't get me wrong, but one has to ... Excel makes you think in math calculations. ... Shelf life of the drug could be loaded once and then access ...
    (microsoft.public.access.tablesdbdesign)
  • Re: WHY
    ... I've been working a lot longer than that LoL ... re-creating the same spreadsheet, ... > I'm sure the database admins do all the work at, say, Boeing and Airbus, ... > Or perhaps you meant implicitly to restrict your remarks to developers. ...
    (microsoft.public.excel)
  • Re: compilers
    ... Pick is superb for the database and the business rules, ... I'll be happy to look hard at OpenQM if I ... This means that whatever back-end database I have to use needs to support ... positions that I do because they are developers, ...
    (comp.databases.pick)
  • Re: Need help on how to organize users and objects
    ... I could assign a custom database role to them though. ... In 2005, if a user creates an sp, which schema does it belong to? ... Security is a huge subject in SQL Server 2005, so I'd suggest you to spend ... the sysadmin; developers and viewers. ...
    (microsoft.public.sqlserver.security)