x

data not loaded from sql job in vmware

Hi,

When i run the package from SSMS, the data is loaded into the corresponding tables BUT when i run the same package using sql job, the job executes without any errors but the data is not loaded. What Could be the reason ?

FYI: I'm using SqlServer 2008 in Windows Server 2008, the VMWARE is running on 64 bit machine.

Thanks,

sqlhungry
more ▼

asked Aug 02 '11 at 03:44 PM in Default

sqlhungry gravatar image

sqlhungry
76 10 10 12

Are there any messages in the package execution log or sql logs?

This type of behavior is often caused by the SQL Service/Agent account not having access to the resources that your user account has (files, mapped drives, other sql servers, etc).
Aug 02 '11 at 03:58 PM KenJ
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first
What is the package doing? There is a log somewhere, either the SQL Agent Log or the SQL Server Log that will have details about any error. By chance are you working with Excel in the package?
more ▼

answered Aug 02 '11 at 04:26 PM

Tim gravatar image

Tim
35.5k 32 40 138

(comments are locked)
10|1200 characters needed characters left
Yes @KenJ is right - this sounds more like an issue with the execution account of the job, which can either be set in the job, or will be run under the account running the SQL Agent Service. This is the difference between running it in SSMS and as a job. Being on VMware will have nothing to do with it.
more ▼

answered Aug 02 '11 at 04:11 PM

Kev Riley gravatar image

Kev Riley ♦♦
50.8k 43 49 76

(comments are locked)
10|1200 characters needed characters left

As you guys suggested, I am debugging the access right and privledges issues.

Thankyou.
more ▼

answered Aug 03 '11 at 12:30 PM

sqlhungry gravatar image

sqlhungry
76 10 10 12

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x673
x85
x6

asked: Aug 02 '11 at 03:44 PM

Seen: 916 times

Last Updated: Aug 02 '11 at 03:44 PM