Q1:
I'm trying to schedule a (local) DTS package wichs reads a
textfile into a table. The DTS package runs fine when
started manualy.
Starting the package from the job (manually or scheduled)
doesn't work.
At first the job seemed to run OK but no data is inserted
in the table. After deleting and re-creating the job the
job retrns following error in eventviewer

SQL Server Scheduled Job 'D3 MeetWaarden Importeren'
(0xBC776CC5E1555141B400516A7F088E95) - Status: Failed -
Invoked on: 2003-09-05 11:20:00 - Message: The job
failed. The Job was invoked by Schedule 7 (D3 MeetWaarden
Importeren). The last step to run was step 1 (D3
MeetWaarden Importeren).

Q2:Is there a way to run a package scheduled every 15
seconds? From the jobscheduler max freq is once per minute.

Any help is hihgly appreciated.

C.

A1. DTS is client side so this is probably related to permissions

http://support.microsoft.com/?kbid=269074


A2. Not using SQL Server Agent Scheduler directly.


You can use a loop which has a WAITFOR delay in their of 15 mins though
before executing the package


--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org