Re: DTS Package scheduled to run as job never runs

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 19:26:04 +0000

In message <138a801c3f89b$c3a97d70$a101280a@phx.gbl>,
"Kphelps@oceanspray.com" <anonymous@discussions.microsoft.com> writes
>I have a dts package that when scheduled via Enterprise
>Manager it does not run. The owner is same as the SQL
>Agent service. When I run it interactively it runs. Does
>any one have any help!
>
>Thanks,
>Katherine Phelps
>Mgr DBA

Double check that the job schedule is enabled. Often the job is fine
itself, enabled and all that, but the schedule has become disabled.

If this is the case and it re-occurs try changing the end time slightly.
Add or subtract minute, ,e.g. use 20:59 as opposed to 21:00 for the end
time. 

-- 
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Relevant Pages

  • Re: dts package and t log
    ... But isn't it possible to start a dts package and as the first step use some ... kind af statement to tell sql not to fill up ... > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > worth of t-log space. ...
    (microsoft.public.sqlserver.dts)
  • Re: Job Scheduler fails and Managing Tempdb
    ... You can turn logging on on both the job and the DTS Package to get some more ... As I said in my previous post, shrinking tempdb is not very useful. ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Limitations of Scheduled jobs
    ... Actually we can schedule the jobs with accuracy less than ... >on what the stored procedure does exactly. ... >SQL Server MVP ... >> I'm using SQL Server 2000 as the DB for my web ...
    (microsoft.public.sqlserver.programming)
  • Source table filtering in DTS by target table values.
    ... I am new to SQL Server and to DTs. ... for the client master. ... file (created in the DTS package) and add them batch by batch ...
    (microsoft.public.sqlserver.dts)
  • Re: Scheduled running of a C# application
    ... > I have an application that creates an Access version of a SQL Server> database and then it moves the resulting database to an ftp server for the> client to download and run reports against etc. ... I would like to be able to modify the application> to receive the params via the commandline and somehow run automatically> off of a set schedule. ...
    (microsoft.public.dotnet.languages.csharp)