Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Executing status on SQL Server Agent Jobs Expand / Collapse
Author
Message
Posted Thursday, November 18, 2010 12:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 18, 2012 1:31 AM
Points: 8, Visits: 60
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



Post #1022645
Posted Thursday, November 18, 2010 2:12 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:55 AM
Points: 1,618, Visits: 20,978
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
Post #1022686
Posted Thursday, November 18, 2010 6:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 18, 2012 1:31 AM
Points: 8, Visits: 60
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



Post #1023248
Posted Thursday, November 18, 2010 7:48 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:55 AM
Points: 1,618, Visits: 20,978
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
Post #1023257
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse