AUTORUN function: Alerts & Subscription with timer

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

SQL Server 2005 Forums

Transact-SQL (2005)

AUTORUN function: Alerts & Subscription with timer

Author

Topic

missMac
Posting Yak Master

124 Posts

Posted - 2008-10-16 : 00:15:09

Hello,
We used to implement an autorun function with a 3rd party software. But the company doesnt support the software anymore.

Whats the best way to go IMPLEMENT this in MS SQL ?

Create an entry in the a table that calls a SP, to run at the users desired time. ie


Name       Event                Run at 
 
Miss Mac     BirthdayReminder       Oct 16-2008 at 12:15 hours 
Customer       Help Me out          Oct 16-2008 at 00:25 hours
user234        Script db            Oct 16-2008 at 09:00 hours
Client2        blah blah            Oct 17-2008 at 15:23 hours
.....

bearing in mind we have thousands of custom entries in a day

e.g. One of the functions is to compute a users daily transaction, which could take 20 -30 mins and in between computation and logging, you can have multiple other tasks STARTED AUTOMATICALLY running simultaneously. And a user can have more than one entry

Is there a timer function, that polls all table entries and starts up the process? Or better ideas ?

Any ideas, on the best way to implement it ? Please

Thanks guys

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-16 : 09:36:06

Yes. A job can be scheduled to run every x seconds/minutes/hours.

E 12°55'05.63"
N 56°04'39.26"

missMac
Posting Yak Master

124 Posts

Posted - 2008-10-16 : 09:42:41

Problem with a job, is that you cant run more than one instance of a job ???

Some of these need to run on a multithread environment. Are there any alternatives to jobs or am i missing something ?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-16 : 09:47:25

As said before, we can't really help until we see your working code.
Maybe we can suggest an alternative approach.

A job should be fine, if your working code is set based and not role based.

E 12°55'05.63"
N 56°04'39.26"

missMac
Posting Yak Master

124 Posts

Posted - 2008-10-17 : 18:45:22

Thanks Peso,
Would have loved to paste my workign code here, but
1. Its based on an NDA
2. Its 700 lines of code which calls 5 functions along the way

3. Before finally calling a BULK_PROCESSING Stored Proc.

Now, stage 3 is most important. Which is where we call the job

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources