Re: Scheduling DTS packages?

Article View: microsoft.public.sqlserver

Article #13

Back to microsoft.public.sqlserver Previous Next

#13

From: Michael Heitmeier
Date: Mon, 08 Mar 1999 00:00

27 lines
1861 bytes

A common pitfall seems to be that not only the job as a total needs to
be enabled but also every schedule (only one in your case), so check
both the package and your schedule.

HTH
Michael


On Fri, 5 Mar 1999 16:17:47 -0800, "Rick Bastedo"
<rbastedo@nospam.gygabite.com> wrote:

>I've successfully set up a DTS package that runs when I right click and
>execute it,
>I want it to run on a schedule so I right click it and go to Schedule. I set
>up the schedule
>to execute it once per day at 08:00 AM. 8 AM comes along and it does not
>happen.
>I've tried over and over and it simply does not work. I've looked in the log
>and it has nothing
>to say. DOes anyone have any idea what I may be doing wrong?
>How about setting this up with dtsrun and the NT scheduler? Is that a good
>alternative?
>
>Rick Bastedo
>info@gygabite.com
>
>

Technical Details

Message-ID: <36e3cb07.1661928817@news.corp.hp.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <7bprtd$j1b$1@remarQ.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10e6bb,4fcb70c9c77c880b
X-Google-Attributes: gid10e6bb,public
X-Google-Thread: 10f695,4fcb70c9c77c880b
X-Google-Attributes: gid10f695,public
X-Google-Thread: 1139e2,4fcb70c9c77c880b
X-Google-Attributes: gid1139e2,public
X-Google-Thread: ff490,4fcb70c9c77c880b
X-Google-Attributes: gidff490,public
X-Google-Thread: 109c00,4fcb70c9c77c880b
X-Google-Attributes: gid109c00,public
X-Google-Thread: 107d2f,4fcb70c9c77c880b
X-Google-Attributes: gid107d2f,public
From: Michael_Heitmeier@nospam.hp.com (Michael Heitmeier)
Subject: Re: Scheduling DTS packages?
Date: 1999/03/08
Message-ID: <36e3cb07.1661928817@news.corp.hp.com>
X-Deja-AN: 453367430
References: <7bprtd$j1b$1@remarQ.com>
Organization: Hewlett Packard Cupertino Site
Newsgroups: microsoft.public.sqlserver,cz.comp.microsoft.sql,microsoft.public.sqlserver.clients,microsoft.public.sqlserver.server,microsoft.public.sqlserver.setup,microsoft.public.sqlserver.workshop

Reply to Parent Message