all groups > sql server dts > february 2004 >
You're in the

sql server dts

group:

Can MSDE 2000 run scheduled DTS Jobs ?



Can MSDE 2000 run scheduled DTS Jobs ? Niall HQ
2/27/2004 2:46:35 AM
sql server dts: I have an application which is networked based, but
allows a local version to be depolyed. The local version
would use MSDE.

The application needs to run a scheduled job on the local
machine to update diary entries for data cahnge while the
user is using it in local mode.

I have looked around but can not see anyone saying if it
is possible to run a scheduled job with MSDE. I have no
problem for the networked system but want this locally.

Any knowledge or ideas I would be happy to receive

Re: Can MSDE 2000 run scheduled DTS Jobs ? Niall HQ
2/27/2004 7:09:18 AM
Allan,
thanks for this reply this is most helpful - I like the
windows scheduler and batch file idea.

Niall


[quoted text, click to view]
Re: Can MSDE 2000 run scheduled DTS Jobs ? Allan Mitchell
2/27/2004 11:26:43 AM
Yes it can. If you have the management tools on another box you can use
that as MSDE has no tools. You can build your own tools using SQLDMO, you
could add jobs by using TSQL sp_add_job.

You can also simply use a batch file which calls DTSRUN and use Windows
Scheduler.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]

AddThis Social Bookmark Button