Post reply

Schedule a DTS package

  • December 4, 2003 at 4:27 am

    #106651

    Hi, like i m a newbie in DTS, i don't understand some thiongs about it. I want to schedule a DTS to be executed as a job. When i right click on my package to schedule it, no problem. When i go to SQL Server Agent/Jobs, i've got nothing ! Why ?

  • December 4, 2003 at 4:41 am

    #484567

    quote:

    Hi, like i m a newbie in DTS, i don't understand some thiongs about it. I want to schedule a DTS to be executed as a job. When i right click on my package to schedule it, no problem. When i go to SQL Server Agent/Jobs, i've got nothing ! Why ?

    Can't explain why the job is not appearing, however, try creating a job excuting the DTS. This isgenerally what I use as I run more than 1 DTS as part of a scheduled Job

    eg using the OS command DTSRUN /S [Server Name] /N [DTS Package Name] /E

  • December 4, 2003 at 6:04 am

    #484578

    Great ! It works well. Thanks for your help. I really appreciate this forum as members are very helpful.

  • December 4, 2003 at 6:23 am

    #484582

    Just another question .... ;-))

    I launch my job and it fails due to an ODBC OLE DB Error. But when i execute the DTS Package directly, no problem.

    Is there a differnce between launching directly and by a job ?

  • December 4, 2003 at 8:43 am

    #484635

    if the job is owned by a sysadmin the package is run uder the context of the SQL Server AGENT service Acccount!

    if the job is owned by non-sysadmin account the Package is runned under the SQLAgentCmdExec account which generally don't have permission ouside of the local computer!!!!

    HTH


    * Noel

  • December 5, 2003 at 12:54 pm

    #484901

    I found the job scheduling security very confusing when I was first starting out. To make it work make sure you are logged in with a user id that is part of the sysadmin role when you are creating the package and the job. Also make sure that the account that the SQL Agent is logged in under has the permissions necessary for all of the processes that are completed within your DTS package, since it is that account that is running the job when it is scheduled.

Viewing 6 posts - 1 through 5 (of 5 total)

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