I created a DTS to run a VB
.net exe from local packages dts.
If I execute the package, it would do what I want.
I scheduled it to be a job running every minute of every day to test out the schedule.
The job status only stays at "Excuting Job Step 1"...and this hangs there forever.
I've check my SQLServerAgent is started.
my sqlserveragent service is run under a username specifically for SQLServer I call "SQLService".
I'm using SQL Server Developer Edition.
Anyone can explain why this is happenning? I'm running into dead alleys here.