Friday, March 9, 2012

Schedule Stored Procedures

Hello all,

I created a stored proceduce to delete specific records from a table. I want it to run every week.

How can I schedule a stored procedure?

I tried with SQL Server Agent -> Jobs, but it isn't a transact SQL-script.

Any ideas?

Thanks in advance.just a thought.... and if you write "exec yourProc" as transact SQL-script?..|||Hello Konstantin,

Thanks for the quick reply. It's working! That simple...

Best regards.

No comments:

Post a Comment