Sql Server 2000 creates a scheduled job to run a stored procedure


Have a client that is using sql server 2000. I know tsql. I need to create a scheduled job that runs a script to create a report from and/or insert data into a seperate table. How do i setup a job to run a sql script? Can anyone point me to a guide on creating reports from these jobs. Thanks. Do i need to create dts packages?

Open SQL Server Enterprise Manager. Expand the Management node. Right Click Job from the Sub Nodes and Select New Job from the context Menu.

You can use THIS to create the jobs.