Automatic execution of Stored Procedures

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Automatic execution of Stored Procedures

Author

Topic

busjjon2
Starting Member

3 Posts

Posted - 2005-10-28 : 09:31:34

Hi,

I need advice on how to automate stored procedures within my SQL2003 DB.

I have a stored procedure I want to automate on 120 second cycle - to link to some external software.

I have little experiance of this and need some pointers on where to research or how to achieve my goal.

Many thanks,

J

X002548
Not Just a Number

15586 Posts

Posted - 2005-10-28 : 09:35:54

>Enterprise Manage>Management>SQL Server Agent>Jobs>Right Click>New Job

Then just schedule the sproc for every 3 minutes.....

Sounds bizarre though...what are you trying to do?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

busjjon2
Starting Member

3 Posts

Posted - 2005-10-28 : 09:42:53

Okay - I have a tracking solution which has data stored on a SQL2003 DB and I then need to transfer this data to front end mapping display which will visualise where the trailers are.

To do this the mapping application will look at one of the SQL tables which needs to be updated on regular basis.

Thanks,

J

busjjon2
Starting Member

3 Posts

Posted - 2005-10-28 : 09:46:04

Okay,

Complete new to this... found the tool but where can i find instructions on what to do??

Or can someone help!!

Thanks,

J

X002548
Not Just a Number

15586 Posts

Posted - 2005-10-28 : 10:28:00

OK

#1 It's either SQL Server 6.5, 7.0, 2000, or 2005

I'll assume 2000

Next, so you just found Enterprise Manager? Did you find it in your Start>Programs>SQL Server menu? If you did, go back there and find Books Online. Start it, and never close it.

If you started Eneterprise Manager for the first time, you are going to have to register a server.

Before I go any further, can you give me what you have done to date, and if I'm up the right path?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources