SQL Server Performance Forum – Threads Archive

I can’t shedule a DTS package ????

I have a DTS package that takes data from an Access Database and then I run a SQL agent to run some TSQL to manipulate the data. the SQl agent runs fine and i can schedule it
however the DTS package can not be scheduled ? you schedule it to run in the future – it never runs when you check it – it was as if it was never scheduled I have no idea what is going on – i’ve checked all the sevices have then correct permissions etc however – It looks like the version of SQL server is the STD edition – could this be the problem ? Any suggestions greatly appreciated Mike.

Check the schedule is enabled. Weird things happen with SQL Server Agent sometimes, although the JOB is scheduled for some reason the schedule itself (which is a seperate, but linked, entity) is disabled. Worth checking… Tom Pullen
DBA, Oxfam GB

Check the SQL Agent log for further information on this job schedule, and the Standard edition has nothing to do with the problem. Right click on the DTS package to schedule and check under SQLAgent–> jobs folder whether the job is created. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks for the info Guys – it turned out that SQL server could not get access to the disk where the data was stored – but could when I ran it manually !!!!

True, thats because of your login privileges and SQLAgent doesn’t have required privileges to process the request. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

that being the case… can you change the directory where the data is stored to a share? or just grant the account that the agent uses access to it?
tanstaafl

]]>