Schedule a DTS package

Question

Schedule a DTS package

doukoud

SSC Veteran

Points: 252
More actions
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 ?

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

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

Ferks Default port Points: 1410 More actions · Answer 1

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

doukoud SSC Veteran Points: 252 More actions · Answer 2

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

doukoud SSC Veteran Points: 252 More actions · Answer 3

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 ?

noeld SSC Guru Points: 96590 More actions · Answer 4

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

amackay_1 Ten Centuries Points: 1240 More actions · Answer 5

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.