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

SQL Agent Job- Foreground Expand / Collapse
Author
Message
Posted Friday, July 11, 2014 2:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 4, 2014 11:28 PM
Points: 3, Visits: 52
Hi...

I have an Issue....

Scenario is:

I have an SSIS package which runs macro. Macro opens ie, pull data and create files. And those files again read by SSIS. This all works fine in BIDS or Visual Studio.

Now I deployed that package in integration services catalogs. And create a SQL Agent job. Now excel and ie opens in background due to that Macro is unable to fetch URL. Hence my job does not finish and keep running .

will anyone please suggest on this?
Post #1591488
Posted Friday, July 11, 2014 3:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:58 AM
Points: 5,369, Visits: 9,891
Two things you have to look out for when you run a package from a SQL Server Agent job:

(1) Interactive components. Things like pop-up messages or user applications will fail.
(2) Permissions. When you run from BIDS, it runs in the context of your Windows login. When it runs as a job, it runs in the context of the SQL Server Agent service account (or proxy account).

You need to take the above into consideration when designing your package.

John
Post #1591491
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse