Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zeeshandar
Starting Member
3 Posts |
 Posted - 2011-03-03 : 00:39:28
|
| Let me explain my question in steps:My hosting server: I have sql server 2008 installed.My local web server: I have sql server 2000 installed.Q1: Is it possible to setup a Job in Sql 2000 that can be than somehow imported to sql 2008?Q2: Is it possible with sql 2008 to schedule an execution of an ASP or PHP or ASP.net file?Actually I want my system to send an automated email to subscriber a day before his account expire. So I need to know how can I do it.Thanks,ZeeshanPixel ManagersConnecting clients via text messaging |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-03-03 : 19:35:17
|
| 1) You can script out your 2000 job and create the necessary item in your 2008 world. Right-click the job for details.2) The xp_cmdshell procedure spawns a Windows command shell and passes in a string for execution.=======================================Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986) |
 |
|
|
|
|
|
Job Schedular