How to setup a stored procedure to be automatically run!

Contributed by
Rating: 4 stars4 stars4 stars4 stars4 stars / 26
September 01, 1999
Rate this Article:
MEH MEH++


SEARCH ASP FREE
TOOLS YOU CAN USE

advertisement

I needed to know how to schedule a stored procedure to run over and over! This is a brief step by step of how to get going. This isn't meant to hold your hand but get you going!

Here is a brief how-to steps!

1. Open SQL Enterprise Manager 
2. Expand the database folder, Select your database if there are several 
databases 
3. Left Single click on the place where it says stored procedures 
4. Right click after selecting and choose new stored procedure 
5. Create and save your stored procedure (Even has a syntax checker!) 
6. Inside Enterprise Manager--Click on Tools, Job Scheduling (A wizard will 
appear) 
7. Click Next 
8 Leave Transact SQL-command selected, Click Next 
9. Verify the database and in the big text box type -- EXEC 
storedprocedurename 
10. Click Next 
11. This will bring up a form that allow you to do whatever. Run now is 
selected. To make it a reoccurring stored proc the 5th option is that. 
12. Schedule how you want the stored proc to run 
13. Choose if you want to email or net send command. If you don't want 
anything click next 
14. To modify or delete the job open SQL Enterprise Manager 
15. Expand the Management Folder, Expand SQL Server Agent, select Jobs. 
16. This is where all the info on the jobs that you created in Job 
Scheduler. 
17. Right Click on the job and choose properties. That's it!

blog comments powered by Disqus
DATABASE CODE ARTICLES

- Deployment of the MobiLink Synchronization M...
- MobiLink Synchronization Wizard in SQL Anywh...
- Finding Matching Records in Data Access Pages
- Using the AccessDataSource Control in VS 2005
- A Closer Look at ADO.NET: The Command Object
- A Closer Look at ADO.NET: The Connection Obj...
- Using ADO to Communicate with the Database, ...
- Code Snippets: Counting Records
- Constraints In Microsoft SQL Server 2000
- Multilingual entries into a DB and to be dis...
- Two combos, one textbox example
- ADO Recordset Paging
- SQL Server Database Creator - .NET Version
- Getting A List of Tables From SQL Server
- Discussion & Listserv Module by Mike Eck...

ASP Web Hosting ASP.Net Web Hosting Windows Web Hosting
 
 
 

ASP Free Forums 
 RSS  Tutorials RSS
 RSS  Forums RSS
 RSS  All Feeds
Site Map 
Request Media Kit
Write For Us Get Paid 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Privacy Policy 
Support 


© 2003-2012 by Developer Shed. All rights reserved. DS Cluster 11 - Follow our Sitemap
Most Popular Topics
All ASP.Net Tutorials