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