September 23, 2004 at 7:45 am
Here's one that is driving me nuts.
I have created a simple DTS (imports a group of tables) which works fine when called from Enterprise Manager. I have scheduled it as a job owned by sa.
When it runs under schedule, I get the following in the Application event log:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 9/23/2004
Time: 4:00:06 AM
User: N/A
Computer: SVVLFP21
Description:
SQL Server Scheduled Job 'Basic400import' (0x545E96ACA5B23D4CB1BA5A4B96B68FEE) - Status: Failed - Invoked on: 2004-09-23 04:00:00 - Message: The job failed. The Job was invoked by Schedule 13 (Basic400import 2). The last step to run was step 1 (Basic400import 2).
**************************************************************
In the package itself, I have "log package execution to SQL server" enabled, but no errors (or any other notices) appear in the SQL logs.
There are other jobs (backups etc) running under server agent without problem, so I assume agent is working correctly.
Can anyone provide input as to what is wrong here?
Jay
...
-- FORTRAN manual for Xerox Computers --
September 23, 2004 at 9:42 am
Hi,
Dim question, but just making sure.. Have you logged onto the server directly (using terminal services) & run the package. Does it work when you do that?
Pete
Peter Gadsby
Business Intelligence Consultant
www.hgconsult.co.uk
September 23, 2004 at 9:47 am
Yes, I can run it from the server under terminal services.
...
-- FORTRAN manual for Xerox Computers --
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply