December 17, 2004 at 8:48 am
Hi.
I'm kind of mucking around with DTS and Lotus Notes to get Notes data into SQL Server tables.
I've created two packages via the Enterprise Manager that I've scheduled to run on a daily basis.
Does the Enterprise Manager need to be running in order for these packages to execute?
If so, is there a way to get them to execute without the Enterprise Manager running?
Thanks.
Doug Dexter
December 17, 2004 at 9:07 am
EM does not need to be running in order for scheduled jobs to run, if you expand the "management" section under your SQL server you will find SQL Server Agent. Expanding that will give you a list of jobs, and the two that you have scheduled, should be there.
It is the SQL Agent (Which should have a green arrow next to it) which needs to run in order for your batch jobs to function.
Note that it will need admin rights (in the services menu) to perform certain fuctions which may prevent your DTS working properly.
Suggest you switch on the logfile option for the DTS at least for the first few times you run it.
December 17, 2004 at 12:15 pm
As said in the previous, no. However what driver are you using to make the calls for notes and have you tested running the SQL Agent by starting the job to run to make sure it will work in that environment?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply