Automate a procedure

  • Thread starter Thread starter tshad
  • Start date Start date
T

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
 
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?
Click to expand...

Windows service.
Windows scheduler.
SQL Server scheduler.

For your situation I would use either a windows service or schedule an
event in SQL server.
 
Lucas Tam said:
Windows service.
Windows scheduler.
SQL Server scheduler.

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

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
 
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?
Click to expand...

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 said:
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.
Click to expand...

Is there a good place to read about this?

I would be very interested in this.

Thanks,

Tom
 
I thought this was only for sending Emails and Faxes?
Click to expand...

In SQL Server 2005, you have full access to the .NET framework, so you can
do whatever you like (within reason... since you don't want to bog the
database server down too much).
 
Back
Top