Mail Alert Process Or Set Scheduler in SQL Database

Mail Alert Process in SQL Server Database
This Process called Scheduler.
when you want to set scheduler in database which checks specific time automatically and send mail to those users whose criteria are match,set Job Functionality in Management tools in SQL server 2000

Steps are Here....

First, open sql server 2000. open Management tools.then open jobs. create new jobs.

there are 4 tabs.
1) General:
- Give name like (beforeads)
- category(uncategorized(local))
- owner(NILSON1\Nilson)
- description(anything)

2) step:
-> new
->Generel:
- step name like(stepads)
- Type like (Activexscript)
- Database like (classified)
- command like(vbscript codding (shaow dailymail.atxt))
3) schedule:
- name like(scheduleads)
- and also set time


If u need more help...put your questions...i will reply u...