November 18, 2010 at 12:46 am
Dear All
i have problem with my Jobs on SQL Server 2005 Agent, when i run the jobs i see status of the jobs is "EXECUTING" but its look not process the package, because the package should be running only for 1 menit, but the SQL Server Agent jobs stil on EXECUTING status after i wait for along time and i need cancel the jobs to stop the jobs .
this My Condition
1. i need to tranfer data form oracle to sql server 2005
2. i create integration service package
3. i am using Proxies to run schedule
please help me ...
thanks
November 18, 2010 at 2:12 am
Check if the Job History has any information as to why the job is not proceeding. You may also add an output file to the Job Step to capture more information on job execution.
Does the SSIS package run fine when not run as a job?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 18, 2010 at 6:33 pm
Hi Adiga
1. first question Job History did not give me information except the cancel process. but i will try to add log file for the jobs.
2. Yes when i run the package from SSIS console is running without any error, and i see my data updated.
Thanks
November 18, 2010 at 7:48 pm
Also make sure that the job owner is "sa" or some other user with sufficient privileges. Also ensure that the SQL Server/Agent startup account has privileges on the folder\files that are being referred in the SSIS package.
Other option to troubleshoot this issue would be to logon to the server with the credentials of the SQL Server service account and then execute the SSIS package manually.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply