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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 how to create job using sql server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-08-22 : 07:01:40
govardhan writes "hai,
how is the createing the job.its my problem is everyday some information send lot of users through email..how....

please clarify me


govardhan"

nr
SQLTeam MVY

12543 Posts

Posted - 2005-08-22 : 08:44:30
In enterprise manager look at
management, sql server agent, jobs.
right click on jobs and new job...
This will allow you to create a scheduled job - probably best to call a store proc from it into which you can code the email send.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -