April 14, 2003 at 2:09 pm
This morning I ran a job which had been run successfully many times before. It has two steps. Both steps succeeded quickly, but EM continued to display "Executing" status for about half an hour.I finally stopped the job manually. Does anyone have any theories about why this happened?
April 14, 2003 at 2:11 pm
Just to clear up - this job has two steps and each one executes a seprate dts package. If anyone could shed some light on this Ii'd really appreciate it!
April 14, 2003 at 2:30 pm
Do you have cubes somewhere?
Check Execute pkg on main thread...this option is in workflow properties.
Also check permissions.
JFB
April 14, 2003 at 2:39 pm
Do your DTS packages send SQL Mail / access network files? Any changes in SQL Server Agent service and proxy accounts? Were both steps failed and can you run them separately?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply