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-04-15 : 08:14:11
|
| KUNAL writes "HIi HAVE CREATED one procedure ( for backup) in master table ...How do i schedule this procedure in sql server on NT machine so it runs on predefined times ...Kunal" |
|
|
kish
Starting Member
45 Posts |
Posted - 2005-04-15 : 08:26:22
|
| YOu can use SQL Server Jobs to schedule under Enterprise Manager. YOu could also use Database Maintainence Planner under Tools menu of EM which can backup your master database at regular intervals, also specify how many backups you want to retain. --Kishore |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-15 : 08:33:57
|
| You can also use sp_add_jobschedule. You can find the syntax in Books Online.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
HOW DO I SCHEDULE PROCEDURES IN SQL SERVER