Hello,

Can anybody tell me how can I schedule a stored procedure to run every 30 minutes?

Thanks in advance,

Palvin

Create a DTS package with a connection object and an execute sql task. Supply the sp name and any parameters. Save the package. Go to enterpise manager and right click on the package name and choose schedule package.

Create a DTS package with a connection object and an execute sql task?????/

Can you explain it briefly please as I am learning SQL.
Thank you

There's no need to create a DTS package for that.

Open the SQL Server Enterprise manager for your server. Expand Management, then SQL Server agent and then click Jobs. Right-click it and choose New Job. You get a screen where you can schedule various SQL Server commands, including running SQL code. For the procedure, create a new step of type Transact SQL Script and type the name of the procedure...

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

I concur with Imar - DTS will be too complicated.

Use EnterpriseManager / {ServerName} / Management / SQL Server Agent / Jobs - Right Click on Jobs and create a New Job ....

Rand

Yes Imar... I forgot you can do it that way. I guess I was just making it harder than it had to be.

Wow!!!!!!!!

Works like a charm. Thanks for your help guys. Imar, thanks for making it so simple for a novice use. It is working great now and my databse is being updated automatically.

Thanks again,
Palvin