sql job failing
Tech-Archive recommends: Fix windows errors by optimizing your registry
Date: Wed, 7 Apr 2004 05:30:27 -0700
Hi Guys,
from sql server 2000 (desk top) i created a link to oracle
7.3 and created a procedure which will update sql tables
and insert into oracle table.
from query analyser i can execute this procedure. but when
i configure a job to execute this procedure it is failing?
any idea
pls advice me.
Relevant Pages
- Re: Parameterised Query vs LookUps
... The data in Oracle is for all time periods but I ... > derived from a UDF in the SQL Server DB. ... > you can execute a look up against a diff connection and use this but i've ...
(microsoft.public.sqlserver.dts) - Re: DTS calling Oracle procedure
... Can someone let me know if there's a way of calling Oracle's procedure within a SQL Server DTS package please. ... The reason for this is that I need to execute the Oracle procedure to extract data from Oracle tables, then manipulate the data and dump the data into a temporary table which then get exported to SQL Server via DTS package. ...
(microsoft.public.sqlserver.dts) - Parameterised Query vs LookUps
... I have a Transform Data Tasks which I'm using to load data from an Oracle DB ... derived from a UDF in the SQL Server DB. ... Select * From OracleDB Where TransactionDate = Result of UDF ... Essentially I need to execute this UDF to get my selected date and then use ...
(microsoft.public.sqlserver.dts) - sql server job failing
... from sql server 2000 i created a link to oracle ... and created a procedure which will update sql tables ... and insert into oracle table. ... from query analyser i can execute this procedure. ...
(microsoft.public.sqlserver.connect) - Re: IOT, memory and transaction time
... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
(comp.databases.oracle.misc) |
|
