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.