Post reply

rephrase of previous question .. Are there any differences

  • July 15, 2004 at 3:41 pm

    #86156

    in how a DTS packages (created with export wizard in Enterprise Manager)  runs when executed:

    1. manually

    versus

    2.  right-clicking that same job (after the scheduling a run time as a job for the package) in Enterprise manager and choosing start job

    versus

    3.  running at a scheduled time?

    My database role is coming across just fine in the export with options 1 & 2, but is only retaining a partial piece of it's actual permissions when executed as option 3.

    Thanks in advance for any help here.

    Chad

     

     

  • July 16, 2004 at 11:33 am

    #514912

    With Steps 1 & 2, you are running the jobs.

    In Step 3 it is scheduled, hence running under the job owner. (You can view/change the job owner by right clicking on the job)

    Steven

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply