Scheduled exec

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi all,

In my recent project (using ASP.NET 2.0 and MSSQL), I need to scheduled a certain operation to be executed, for example, on beginning of a month.
Is there anyway to do this on server-side, either on ASP.NET side or SQL Server side?

Many thanks in advance,
Mike
 
Use SQL Agent and Jobs. ASP.Net has nothing to do with this approach.


--
JS
BRE Bank Dev Team, Poland
Uzytkownik "Mike" <[email protected]> napisal w wiadomosci Hi all,

In my recent project (using ASP.NET 2.0 and MSSQL), I need to scheduled a certain operation to be executed, for example, on beginning of a month.
Is there anyway to do this on server-side, either on ASP.NET side or SQL Server side?

Many thanks in advance,
Mike
 
Thanks Jacek,

How to do this, as I'm new to this. Can you please provide a sample script or further reference for this?

thanks,
andy

Use SQL Agent and Jobs. ASP.Net has nothing to do with this approach.


--
JS
BRE Bank Dev Team, Poland
Uzytkownik "Mike" <[email protected]> napisal w wiadomosci Hi all,

In my recent project (using ASP.NET 2.0 and MSSQL), I need to scheduled a certain operation to be executed, for example, on beginning of a month.
Is there anyway to do this on server-side, either on ASP.NET side or SQL Server side?

Many thanks in advance,
Mike
 
Hi Eli,

I don't think I can use a Windows sched task job, because I'll run it on a shared-server (with a hosting).

thanks,
andy

SQL Server has a job scheduler. You can also setup a Windows scheduled task on the server

Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

Hi all,

In my recent project (using ASP.NET 2.0 and MSSQL), I need to scheduled a certain operation to be executed, for example, on beginning of a month.
Is there anyway to do this on server-side, either on ASP.NET side or SQL Server side?

Many thanks in advance,
Mike
 
SQL Server has a job scheduler. You can also setup a Windows scheduled task on the server

Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

Hi all,

In my recent project (using ASP.NET 2.0 and MSSQL), I need to scheduled a certain operation to be executed, for example, on beginning of a month.
Is there anyway to do this on server-side, either on ASP.NET side or SQL Server side?

Many thanks in advance,
Mike
 
Then they might not let use their SQL Server job scheduler either. Ask your host.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

Hi Eli,

I don't think I can use a Windows sched task job, because I'll run it on a shared-server (with a hosting).

thanks,
andy

SQL Server has a job scheduler. You can also setup a Windows scheduled task on the server

Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

Hi all,

In my recent project (using ASP.NET 2.0 and MSSQL), I need to scheduled a certain operation to be executed, for example, on beginning of a month.
Is there anyway to do this on server-side, either on ASP.NET side or SQL Server side?

Many thanks in advance,
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top