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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-10 : 07:56:19
|
| Berna writes "I need to delete the data of a table every 2 weeks on Monday, What service can I use? Stored Procedures? or Jobs? If you recommend me a job, Do I have to use sp_add_job , sp_add_jobsteps and sp_add_jobschedule to create it?" |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-05-10 : 08:04:03
|
| If you have enterprize manager on your PC It is easyer to use that.Go to mangement, SQL server agent, jobs, Right click on the blank area and select new job.JimUsers <> Logic |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-05-10 : 08:09:58
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49433DamianIta erat quando hic adveni. |
|
|
|
|
|
|
How can I do a Schedule Stored Procedure?