Scedule a job?

[ayladilara]

I have a database on SQL Server 7. The database has been created and populated via ODBC with a batch file on the source DBMS(non Microsoft) and has been running on the ASP Pages on the local intranet. So far everything is fine.
Now, I need to create an ongoing automoted ( maybe daily or weekly basis) data importing process.
How shall I go about it?
Any insight?

Many Thanks.

 

[alfredp77]

where do you want to import the data? to a file? or directly to the other dbms?
you can actually use "Jobs" (via Enterprise Manager, under Management - SQL Server Agent - Jobs) to schedule automated jobs. it's powerful enough, you can run external programs, execute queries etc.

 

[ayladilara]

From the other DBMS(non-Microsoft) onto the SQL Server.This has been done by a file written in completely different language,which runs on OpenInsight and populates the database (via ODBC) on the SQL Server. I know "Jobs". In that case, how can I get it recignosed and scheduled this external process(program)? Or do I have to use DTS and create a package first and later write an AciveX script to automate it?

 

[alfredp77]

you can specify the type of job to run as "Operating System Command (CmdExec)" when you add new step to your SQL Server scheduled job. you can ask SQL Server to execute the import program.

 

[ayladilara]

Thank you alfredp77. I'll try .