Automate a procedure

[tshad]

If I want to automate a procedure, in this case, every hour read through my
new applicants that have applied on the web in the least hour and send an
email to them, what is the best way to handle that?

Can it be done with Asp.Net?

Or run a Windows service?

Or some other way?

Thanks,

Tom

 

[Lucas Tam]

If I want to automate a procedure, in this case, every hour read
through my new applicants that have applied on the web in the least
hour and send an email to them, what is the best way to handle that?

Can it be done with Asp.Net?

Or run a Windows service?

Windows service.
Windows scheduler.
SQL Server scheduler.

For your situation I would use either a windows service or schedule an
event in SQL server.

 

[tshad]

Windows service.
Windows scheduler.
SQL Server scheduler.

For your situation I would use either a windows service or schedule an
event in SQL server.

How do you schedule an event in Sql Server?

Can you schedule an event in Sql Server to respond to a request from another
Sql Server on another machine - kind of like responding to a mouseclick in
an application?

Thanks,

Tom

 

[Lucas Tam]

Can you schedule an event in Sql Server to respond to a request from
another Sql Server on another machine - kind of like responding to a
mouseclick in an application?

You can use a trigger for responding to events.

However, I believe SQL Server 2005 will have true events - it can even fire
off .NET processes.

To schedule an event, in Enterprise manager, select your SQL Server
registration. Select the Management Folder. Select SQL Server Agent. Select
Jobs.

 

[Lucas Tam]

Is there a good place to read about this?

I would be very interested in this.

Take a look at:

http://www.awprofessional.com/content/images/0321247124/samplechapter/homer
_ch05.pdf

Under Notification Services.

FYI, SQL Server 2005 will have support for the .NET framework... so you
could always load your own .NET objects to handle custom scenarios : )

 

[Lucas Tam]

Is there a good place to read about this?

I would be very interested in this.

BTW, this might be relavant too:

http://www.devx.com/dotnet/Article/21286

Managed (.NET) Stored Procedures