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]

"tshad" <ts**********@ftsolutions.com> wrote in
news:uw**************@TK2MSFTNGP14.phx.gbl:

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.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[tshad]

"Lucas Tam" <RE********@rogers.com> wrote in message
news:Xn***************************@127.0.0.1...

"tshad" <ts**********@ftsolutions.com> wrote in
news:uw**************@TK2MSFTNGP14.phx.gbl:

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.

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 (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Lucas Tam]

"tshad" <ts**********@ftsolutions.com> wrote in
news:#1**************@TK2MSFTNGP14.phx.gbl:

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 (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[tshad]

"Lucas Tam" <RE********@rogers.com> wrote in message
news:Xn***************************@127.0.0.1...

"tshad" <ts**********@ftsolutions.com> wrote in
news:#1**************@TK2MSFTNGP14.phx.gbl:

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.

Is there a good place to read about this?

I would be very interested in this.

Thanks,

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

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Lucas Tam]

"tshad" <ts**********@ftsolutions.com> wrote in news:#oqa5BSpFHA.1444
@tk2msftngp13.phx.gbl:

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

Is there a good place to read about this?

I would be very interested in this.

Take a look at:

http://www.awprofessional.com/conten...echapter/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 (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Lucas Tam]

"tshad" <ts**********@ftsolutions.com> wrote in news:#oqa5BSpFHA.1444
@tk2msftngp13.phx.gbl:

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

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

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[tshad]

"Lucas Tam" <RE********@rogers.com> wrote in message
news:Xn***************************@127.0.0.1...

"tshad" <ts**********@ftsolutions.com> wrote in news:#oqa5BSpFHA.1444
@tk2msftngp13.phx.gbl:

However, I believe SQL Server 2005 will have true events - it can even
fire
off .NET processes.
Is there a good place to read about this?

I would be very interested in this.

Take a look at:

http://www.awprofessional.com/conten...echapter/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 : )
I thought this was only for sending Emails and Faxes?

Tom
--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Lucas Tam]

"tshad" <tf*@dslextreme.com> wrote in news:eLi9enspFHA.2504
@tk2msftngp13.phx.gbl:

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 : )

I thought this was only for sending Emails and Faxes?

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).

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/