SQL Server Agent 2005 job runs but provides no output
Posted
by alimack
on Server Fault
See other posts from Server Fault
or by alimack
Published on 2010-04-21T09:58:29Z
Indexed on
2010/04/21
10:03 UTC
Read the original article
Hit count: 406
Essentially I have a job which runs in BIDS and as as a stand lone package and while it runs under the SQL Server Agent it doesn't complete properly (no error messages though).
The job steps are:
1) Delete all rows from table;
2) Use For each loop to fill up table from Excel spreasheets;
3) Clean up table.
I've tried this MS page (steps 1 & 2), didn't see any need to start changing from Server side security.
Also SQLServerCentral.com for this page, no resolution.
How can I get error logging or a fix?
© Server Fault or respective owner
