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 |
|
acko
Yak Posting Veteran
52 Posts |
 Posted - 2003-07-09 : 08:27:33
|
| HiI made a job, in EM which main tasks to backup two databases every day in the same time.But I am interested can i make this job to run only on workdays and not on weekend.ThanksAlex |
|
|
REDDY
Starting Member
43 Posts |
Posted - 2003-07-09 : 08:44:13
|
| Yes You can,if I understand you correctly.You can do this as belowJobs-->select your job properties--->Schedules--->edit-->change-->select the week days from this window. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-09 : 12:32:24
|
| Why would you not want to run backups on the weekend though? Just because the weekend doesn't have anyone making changes to the database doesn't mean that changes aren't happening. Do you run database maintenance on the weekend? If so, your backups should run on the weekend as well to pick up those changes.Tara |
|
|
|
|
|
|
WorkDayJob