sql server dts:
Right click on the package -> Schedule Package.
This will create a job under Management -> SQL Server Agent -> Jobs.
Right click on the package -> Package Logs.
The SQl Server Agent must be started.
Does it work now? Any further assistance?
Good luck.
[quoted text, click to view] Jennie Pao wrote:
> Hi,
>
> I am new to DTS world. I was able to save a dts package (in local packages)
> and execute it manually without problem. I am trying to schedule it to run
> daily but nothing happened on scheduled time. Could anyone please point me
> out? Where can I check the log? Thanks.
Hi,
I am new to DTS world. I was able to save a dts package (in local packages)
and execute it manually without problem. I am trying to schedule it to run
daily but nothing happened on scheduled time. Could anyone please point me
out? Where can I check the log? Thanks.
Whilst it is possible to Schedule a package by right clicking on the package
in EM and selecting schedule I prefer not to do this as it creates a
hexadecimal encrypted version of the command line. I prefer to use a
Operating System (CmdExec step to run DTSRun myself.
If the syntax is confusing then you could try here
Getting Syntax Help for DTSRun
(
http://www.sqldts.com/default.aspx?301)
and don't forget this one
http://support.microsoft.com/?kbid=269074 --
Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com [quoted text, click to view] "Jennie Pao" <email@msn.com> wrote in message
news:ux0IwbbsGHA.4992@TK2MSFTNGP02.phx.gbl...
> Hi,
>
> I am new to DTS world. I was able to save a dts package (in local
> packages) and execute it manually without problem. I am trying to
> schedule it to run daily but nothing happened on scheduled time. Could
> anyone please point me out? Where can I check the log? Thanks.
>
