SQL server 2005 Create Scheduled Job
Posted on 2011-02-20
In SQL server 2005, I have two queries that I need to run as scheduled job with daily refresh.
These are the queries:
DELETE OPENQUERY ([MYLinkedServer], 'select * from Target_tab');
INSERT INTO OPENQUERY([MYLinkedServer], 'select fid, FName from Target_tab')
select TNumber, FName from dbo.Source_tab;
The above queries run well on the SQL server 2005. The target is an Oracle database.
How do I create a scheduled job for these two queries on the SQL server?