General discussion


SQL Srvr sched package still exec ing

By kenvickers ·
In SQL Server 7 I am trying to use a scheduled DTS to export data to flat files every 10 minutes for another developers application to pick up.

I find that occasionally the Job is still executing and therefore it stops running.

Is there anything that I should be doing?

BTW. The other application is not yet switched on so I doubt that it is caused by access to the output file.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Srvr sched package still exec ing

by Shanghai Sam In reply to SQL Srvr sched package st ...

You need to look at how long it generally takes for the package to run. Run it manually to determine what part of the package is causing it to take so long.

There's vary little that I can tell you from your description. If you want to send me an email on post in here exactly what the package does.

If all it does is export the data, are you exporting a table, a view, or query results? How much data is being exported? How many records and how many fields, on average?

Related Discussions

Related Forums