p2p.wrox.com: Archives - asp_web

asp_web_howto thread: scheduling stored procedures

Message #1 by "Nick" <nick@f...> on Thu, 20 Dec 2001 11:08:56

Hi,



I have an asp page that i run every day that calls SQL server stored 

procedures. Is there any way i can automate SQL server to run these every 

day rather that have the ASP script run every day?



thanks,



Nick

Message #2 by Joe Ingle <Joe@k...> on Thu, 20 Dec 2001 11:52:36 -0000

Can you not schedule as a job in SQL Server??



-----Original Message-----

From: Nick [mailto:nick@f...]

Sent: Thursday, December 20, 2001 11:09

To: ASP Web HowTo

Subject: [asp_web_howto] scheduling stored procedures





Hi,



I have an asp page that i run every day that calls SQL server stored 

procedures. Is there any way i can automate SQL server to run these every 

day rather that have the ASP script run every day?



thanks,



Nick




$subst('Email.Unsub').

Message #3 by Nick Charlesworth <nick@f...> on Thu, 20 Dec 2001 11:11:31 -0000

how do you do that?



-----Original Message-----

From: Joe Ingle [mailto:Joe@k...]

Sent: 20 December 2001 11:53

To: ASP Web HowTo

Subject: [asp_web_howto] RE: scheduling stored procedures





Can you not schedule as a job in SQL Server??



-----Original Message-----

From: Nick [mailto:nick@f...]

Sent: Thursday, December 20, 2001 11:09

To: ASP Web HowTo

Subject: [asp_web_howto] scheduling stored procedures





Hi,



I have an asp page that i run every day that calls SQL server stored 

procedures. Is there any way i can automate SQL server to run these every 

day rather that have the ASP script run every day?



thanks,



Nick




$subst('Email.Unsub').






$subst('Email.Unsub').

Message #4 by "NaveenG" <naveeng@s...> on Sat, 20 Jan 2001 17:00:52 +0530

Hi Nick,

Can we schedule ASP run everyday? If so please give me the details,

Thanks

-Nav

----- Original Message -----

From: Joe Ingle <Joe@k...>

To: ASP Web HowTo <asp_web_howto@p...>

Sent: Thursday, December 20, 2001 5:22 PM

Subject: [asp_web_howto] RE: scheduling stored procedures





> Can you not schedule as a job in SQL Server??

>

> -----Original Message-----

> From: Nick [mailto:nick@f...]

> Sent: Thursday, December 20, 2001 11:09

> To: ASP Web HowTo

> Subject: [asp_web_howto] scheduling stored procedures

>

>

> Hi,

>

> I have an asp page that i run every day that calls SQL server stored

> procedures. Is there any way i can automate SQL server to run these every

> day rather that have the ASP script run every day?

>

> thanks,

>

> Nick




> $subst('Email.Unsub').

>




$subst('Email.Unsub').

Message #5 by Abdel.Ramli@w... on Thu, 20 Dec 2001 13:31:27 +0200

why don't u check time and date, refresh page on a regular basis and

undertake action u want on the given time.

just a suggestion





-----Message d'origine-----

De: NaveenG [mailto:naveeng@s...]

Date: samedi 20 janvier 2001 12:31

=C0: ASP Web HowTo

Objet: [asp_web_howto] RE: scheduling stored procedures





Hi Nick,

Can we schedule ASP run everyday? If so please give me the details,

Thanks

-Nav

----- Original Message -----

From: Joe Ingle <Joe@k...>

To: ASP Web HowTo <asp_web_howto@p...>

Sent: Thursday, December 20, 2001 5:22 PM

Subject: [asp_web_howto] RE: scheduling stored procedures





> Can you not schedule as a job in SQL Server??

>

> -----Original Message-----

> From: Nick [mailto:nick@f...]

> Sent: Thursday, December 20, 2001 11:09

> To: ASP Web HowTo

> Subject: [asp_web_howto] scheduling stored procedures

>

>

> Hi,

>

> I have an asp page that i run every day that calls SQL server stored

> procedures. Is there any way i can automate SQL server to run these 

every

> day rather that have the ASP script run every day?

>

> thanks,

>

> Nick




> $subst('Email.Unsub').

>




$subst('Email.Unsub').








$subst('Email.Unsub').

Message #6 by Sam Clohesy <sam@e...> on Thu, 20 Dec 2001 11:32:54 -0000

Could make a few changes to the page and run  as a scheduled .vbs?



Sam





-----Original Message-----

From: Abdel.Ramli@w... [mailto:Abdel.Ramli@w...]

Sent: 20 December 2001 11:31

To: ASP Web HowTo

Subject: [asp_web_howto] RE: scheduling stored procedures





why don't u check time and date, refresh page on a regular basis and

undertake action u want on the given time.

just a suggestion





-----Message d'origine-----

De: NaveenG [mailto:naveeng@s...]

Date: samedi 20 janvier 2001 12:31

=C0: ASP Web HowTo

Objet: [asp_web_howto] RE: scheduling stored procedures





Hi Nick,

Can we schedule ASP run everyday? If so please give me the details,

Thanks

-Nav

----- Original Message -----

From: Joe Ingle <Joe@k...>

To: ASP Web HowTo <asp_web_howto@p...>

Sent: Thursday, December 20, 2001 5:22 PM

Subject: [asp_web_howto] RE: scheduling stored procedures





> Can you not schedule as a job in SQL Server??

>

> -----Original Message-----

> From: Nick [mailto:nick@f...]

> Sent: Thursday, December 20, 2001 11:09

> To: ASP Web HowTo

> Subject: [asp_web_howto] scheduling stored procedures

>

>

> Hi,

>

> I have an asp page that i run every day that calls SQL server stored

> procedures. Is there any way i can automate SQL server to run these 

every

> day rather that have the ASP script run every day?

>

> thanks,

>

> Nick




> $subst('Email.Unsub').

>




$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').

Message #7 by "NaveenG" <naveeng@s...> on Thu, 20 Dec 2001 17:36:30 +0530

scheduled .vbs? Can u please explain me a little bit more? If u have a code,

please send me.

-Nav

----- Original Message -----

From: Sam Clohesy <sam@e...>

To: ASP Web HowTo <asp_web_howto@p...>

Sent: Thursday, December 20, 2001 5:02 PM

Subject: [asp_web_howto] RE: scheduling stored procedures





Could make a few changes to the page and run  as a scheduled .vbs?



Sam





-----Original Message-----

From: Abdel.Ramli@w... [mailto:Abdel.Ramli@w...]

Sent: 20 December 2001 11:31

To: ASP Web HowTo

Subject: [asp_web_howto] RE: scheduling stored procedures





why don't u check time and date, refresh page on a regular basis and

undertake action u want on the given time.

just a suggestion





-----Message d'origine-----

De: NaveenG [mailto:naveeng@s...]

Date: samedi 20 janvier 2001 12:31

�: ASP Web HowTo

Objet: [asp_web_howto] RE: scheduling stored procedures





Hi Nick,

Can we schedule ASP run everyday? If so please give me the details,

Thanks

-Nav

----- Original Message -----

From: Joe Ingle <Joe@k...>

To: ASP Web HowTo <asp_web_howto@p...>

Sent: Thursday, December 20, 2001 5:22 PM

Subject: [asp_web_howto] RE: scheduling stored procedures





> Can you not schedule as a job in SQL Server??

>

> -----Original Message-----

> From: Nick [mailto:nick@f...]

> Sent: Thursday, December 20, 2001 11:09

> To: ASP Web HowTo

> Subject: [asp_web_howto] scheduling stored procedures

>

>

> Hi,

>

> I have an asp page that i run every day that calls SQL server stored

> procedures. Is there any way i can automate SQL server to run these every

> day rather that have the ASP script run every day?

>

> thanks,

>

> Nick




> $subst('Email.Unsub').

>




$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').






$subst('Email.Unsub').

Message #8 by Nick Charlesworth <nick@f...> on Thu, 20 Dec 2001 12:01:59 -0000

no, but you cant schedule asp to run every day but you can create a VB

Script file (.vbs file) that you can you can schedule to run whenever you

want. 



To convert an ASP file to a VB script file you must remove all references to

the ASP object model.



i.e. any Response, Request, Session, Application references and any <% %>

tags



-----Original Message-----

From: NaveenG [mailto:naveeng@s...]

Sent: 20 January 2001 11:31

To: ASP Web HowTo

Subject: [asp_web_howto] RE: scheduling stored procedures





Hi Nick,

Can we schedule ASP run everyday? If so please give me the details,

Thanks

-Nav

----- Original Message -----

From: Joe Ingle <Joe@k...>

To: ASP Web HowTo <asp_web_howto@p...>

Sent: Thursday, December 20, 2001 5:22 PM

Subject: [asp_web_howto] RE: scheduling stored procedures





> Can you not schedule as a job in SQL Server??

>

> -----Original Message-----

> From: Nick [mailto:nick@f...]

> Sent: Thursday, December 20, 2001 11:09

> To: ASP Web HowTo

> Subject: [asp_web_howto] scheduling stored procedures

>

>

> Hi,

>

> I have an asp page that i run every day that calls SQL server stored

> procedures. Is there any way i can automate SQL server to run these every

> day rather that have the ASP script run every day?

>

> thanks,

>

> Nick




> $subst('Email.Unsub').

>




$subst('Email.Unsub').








$subst('Email.Unsub').

Message #9 by "Jason Salas" <jason@k...> on Thu, 20 Dec 2001 21:58:53 +1000

You can configure and run Windows Script Host to schedule and automate the

times when a script fires on your server.



HTH,

Jason





----- Original Message -----

From: "Sam Clohesy" <sam@e...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Thursday, December 20, 2001 9:32 PM

Subject: [asp_web_howto] RE: scheduling stored procedures





Could make a few changes to the page and run  as a scheduled .vbs?



Sam





-----Original Message-----

From: Abdel.Ramli@w... [mailto:Abdel.Ramli@w...]

Sent: 20 December 2001 11:31

To: ASP Web HowTo

Subject: [asp_web_howto] RE: scheduling stored procedures





why don't u check time and date, refresh page on a regular basis and

undertake action u want on the given time.

just a suggestion





-----Message d'origine-----

De: NaveenG [mailto:naveeng@s...]

Date: samedi 20 janvier 2001 12:31

�: ASP Web HowTo

Objet: [asp_web_howto] RE: scheduling stored procedures





Hi Nick,

Can we schedule ASP run everyday? If so please give me the details,

Thanks

-Nav

----- Original Message -----

From: Joe Ingle <Joe@k...>

To: ASP Web HowTo <asp_web_howto@p...>

Sent: Thursday, December 20, 2001 5:22 PM

Subject: [asp_web_howto] RE: scheduling stored procedures





> Can you not schedule as a job in SQL Server??

>

> -----Original Message-----

> From: Nick [mailto:nick@f...]

> Sent: Thursday, December 20, 2001 11:09

> To: ASP Web HowTo

> Subject: [asp_web_howto] scheduling stored procedures

>

>

> Hi,

>

> I have an asp page that i run every day that calls SQL server stored

> procedures. Is there any way i can automate SQL server to run these every

> day rather that have the ASP script run every day?

>

> thanks,

>

> Nick




> $subst('Email.Unsub').

>




$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').






$subst('Email.Unsub').

Message #10 by "Ken Schaefer" <ken@a...> on Thu, 20 Dec 2001 23:18:27 +1100

SQL Server has an SQL Server Agent. Schedule a job using that. In EM goto

Management, then Jobs, then choose "new job".



If you don't have sufficient access to set this up, create a little .vbs

file and use the Windows Task Scheduler to run the .vbs file every day.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Nick" <nick@f...>

Subject: [asp_web_howto] scheduling stored procedures





: I have an asp page that i run every day that calls SQL server stored

: procedures. Is there any way i can automate SQL server to run these every

: day rather that have the ASP script run every day?



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Message #11 by "Ken Schaefer" <ken@a...> on Thu, 20 Dec 2001 23:48:48 +1100

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/ht

ml/vtoriMicrosoftWindowsScriptTechnologies.asp?frame=true



Cheers

Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "NaveenG" <naveeng@s...>

To: "ASP Web HowTo" <asp_web_howto@p...>





: scheduled .vbs? Can u please explain me a little bit more? If u have a

code,

: please send me.

: -Nav

: ----- Original Message -----

: From: Sam Clohesy <sam@e...>

: To: ASP Web HowTo <asp_web_howto@p...>

: Sent: Thursday, December 20, 2001 5:02 PM

: Subject: [asp_web_howto] RE: scheduling stored procedures

:

:

: Could make a few changes to the page and run  as a scheduled .vbs?

:

: Sam

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Message #12 by Kyle Burns <kburns@c...> on Thu, 20 Dec 2001 13:55:38 -0500

I say use the right tool for the right job.  If you need to do things 

other

that running your procs, then the combination of WSH/Task Scheduler 

would be

your best bet.  If you only need to run your stored procedures, then

schedule the job in SQL Agent.  Why find a "work around" like 

scheduling the

running of an ASP page when tools are provided for the purpose of what 

you

want to accomplish?







=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

=3D=3D=3D=3D=3D=3D=3D=3D=3D

Kyle M. Burns, MCSD, MCT

ECommerce Technology Manager

Centra Credit Union

kburns@c...







>> -----Original Message-----

>> From: Jason Salas [mailto:jason@k...]

>> Sent: Thursday, December 20, 2001 6:59 AM

>> To: ASP Web HowTo

>> Subject: [asp_web_howto] RE: scheduling stored procedures

>>

>>

>> You can configure and run Windows Script Host to schedule

>> and automate the

>> times when a script fires on your server.

>>

>> HTH,

>> Jason

>>

>>

>> ----- Original Message -----

>> From: "Sam Clohesy" <sam@e...>

>> To: "ASP Web HowTo" <asp_web_howto@p...>

>> Sent: Thursday, December 20, 2001 9:32 PM

>> Subject: [asp_web_howto] RE: scheduling stored procedures

>>

>>

>> Could make a few changes to the page and run  as a scheduled .vbs?

>>

>> Sam

>>

>>

>> -----Original Message-----

>> From: Abdel.Ramli@w... [mailto:Abdel.Ramli@w...]

>> Sent: 20 December 2001 11:31

>> To: ASP Web HowTo

>> Subject: [asp_web_howto] RE: scheduling stored procedures

>>

>>

>> why don't u check time and date, refresh page on a regular basis and

>> undertake action u want on the given time.

>> just a suggestion

>>

>>

>> -----Message d'origine-----

>> De: NaveenG [mailto:naveeng@s...]

>> Date: samedi 20 janvier 2001 12:31

>> =C0: ASP Web HowTo

>> Objet: [asp_web_howto] RE: scheduling stored procedures

>>

>>

>> Hi Nick,

>> Can we schedule ASP run everyday? If so please give me the details,

>> Thanks

>> -Nav

>> ----- Original Message -----

>> From: Joe Ingle <Joe@k...>

>> To: ASP Web HowTo <asp_web_howto@p...>

>> Sent: Thursday, December 20, 2001 5:22 PM

>> Subject: [asp_web_howto] RE: scheduling stored procedures

>>

>>

>> > Can you not schedule as a job in SQL Server??

>> >

>> > -----Original Message-----

>> > From: Nick [mailto:nick@f...]

>> > Sent: Thursday, December 20, 2001 11:09

>> > To: ASP Web HowTo

>> > Subject: [asp_web_howto] scheduling stored procedures

>> >

>> >

>> > Hi,

>> >

>> > I have an asp page that i run every day that calls SQL

>> server stored

>> > procedures. Is there any way i can automate SQL server to

>> run these every

>> > day rather that have the ASP script run every day?

>> >

>> > thanks,

>> >

>> > Nick




>> > $subst('Email.Unsub').

>> >




>> $subst('Email.Unsub').

>>

>>




>> $subst('Email.Unsub').

>>




>> $subst('Email.Unsub').

>>




>> $subst('Email.Unsub').

>>

>>

>>




>> $subst('Email.Unsub').

>>

Return to Index

P2P Archives