Running job error in schedule

Dear All,

I set the scheduler to run a stored procedure and it casyes error. Failed to run the stored procedure but when running it manually from the query analyser it works just fine.

This is the error.

SQL Server Scheduled Job ¡°Job ABC¡± (0xE708F39963C95A4390BC3C99E6A029AC) ¨C Status: Failed ¨C Invoked on 2006-12-10 03:00:00 ¨C Message: The job failed. The job was invoked by Schedule 7.

Could anyone please advise what should be the problem


Regards,

LG

Dear rottengeek,

I have found that there is no that check box saying show step details. Please advise if you have any further instructions.

Regards,

LG

Dear Satya SKJ,

Thanks for response. Actually the job run 20% successfully. We run the calculate and update the tables and only 20% of the table is properly updated after that it fails. But if we use the same script to run on the query analyser it works just fine. We assign the job to SA.

This means that there must be something wrong with the job. It used to work okay before but just these few days.

Please advise.

Regards,

LG

Hi all,

I've the same exact problem for the last few weeks, the job is working fine manually but it fails when I set it as scheduled

Here is the Job history log:

Executed as user: Dom\MyUser. ... Executing... DTSRun OnStart: Copy Data from eoa_exchange to [TrgtSQLSrvr].[dbo].[EC_Ge_En_Hr_load] Step DTSRun OnStart: Copy Data from eoa_gen to [TrgtSQLSrvr].[dbo].[EC_Ge_Hr_loads] Step DTSRun OnError: Copy Data from eoa_exchange to [TRGTSQLSRVR].[dbo].[EC_Ge_En_Hr_load] Step, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: Error source: Help file: Help context: 0 DTSRun OnFinish: Copy Data from eoa_exchange to [TRGTSQLSRVR].[dbo].[EC_Ge_En_Hr_load] Step DTSRun OnError: Copy Data from eoa_gen to [TRGTSQLSRVR].[dbo].[EC_Ge_Hr_loads] Step, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Conn. The step failed.

I'm not sure if it's because of any previous update (Automatic Windows Update)

I've SQL Server Enterprise 2000 + SP3

Any help will be appreciated

Thanks,

Dear Satya SKJ,

Thanks for your response. It's hard to say indeed as the job calls a procedure to process calculation. The same routine and the same database with exact same data, it works just fine. But when running in the job, it keeps failing.

Regards,

LG