I have a stored procedure.
I need to create a scheduled job using that stored procedure.
I went to Enterprise Manager -->Management--> Jobs-->New Job
Properties
In the step tab, I can select db and put the codes.
Instead of writing the code there, I want to call the stored procedure
in the command box.
How can I do that?
System: MS SQL Server 2000
I would highly appreciate your help.
Thanks a million in advance.
Best regards,
mamunIn the Type Dropdown, select T-SQL & call your stored procedure like:
EXEC usp...
--
- Anith
( Please reply to newsgroups only )
No comments:
Post a Comment