Re: sql event viewer error

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

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 10/05/04 

Date: Mon, 04 Oct 2004 19:49:17 -0600

Check the job history for New Package. In Enterprise
Manager, right click on the job and select View History. In
the Job History window, select the option to Show Step
Details. Then view the details of the job failure. If it's a
DTS package that runs fine manually but not when scheduled
as a job, you can refer to the following:
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/?id=269074

-Sue

On Mon, 4 Oct 2004 00:23:03 -0700, "David"
<David@discussions.microsoft.com> wrote:

>hi!
>
>I'm constantly getting the msg below hourly in the event viewer.
>
>SQL Server Scheduled Job 'New Package' (0x4EB62AE314B91F4A817984863DE480AD)
>- Status: Failed - Invoked on: 2004-10-03 14:00:00 - Message: The job failed.
> The Job was invoked by Schedule 1 (New Package). The last step to run was
>step 1 (New Package).
>
>Any idea how to troubleshoot what's the problem?
>
>Thks!

Relevant Pages

  • Re: Change in sa password, scheduled jobs failing
    ... >The only problem with that is that they lose the job history ... >Package functionality of the package. ... then you could write some SQL to generate some update code. ... global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: Exporting Data
    ... sysjobhistory table in MSDB stores the job history. ... You can also specify at DTS package level to save package execution (package ... sysdtspackagelog and sysdtssteplof tables in MSDB. ...
    (microsoft.public.sqlserver.dts)
  • DTS Problem
    ... I have a DTS that is scheduled. ... The package it runs will run perfectly while running manually ... it appears to get stuck on the first step till i ... then in the job history i would see 'job was canceled' ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS issue on SQL 2k
    ... When the DTS package runs as a scheduled job, it is not running as you. ... Either the SQL Server service account or the SQL Agent Proxy account is ...
    (microsoft.public.sqlserver.dts)
  • Re: importing xls file - different attempt - one result....
    ... Why not use the wizard to create the exact DTS package you need to import XLS files? ... Dim oConnection as DTS.Connection2 ... Dim oColumn As DTS.Column ...
    (microsoft.public.sqlserver.dts)