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 |
|
AlanS
Starting Member
28 Posts |
 Posted - 2004-03-24 : 12:13:53
|
| I'm setting up a number of new backup jobs, in each case scheduling the job to run every week at 11:00 PM on a day that varies with the job. In most cases, when I get to the last screen of the wizard and click OK or Finish, I simply get a message that the job has been created successfully. But in several cases, for jobs that were set to run on Wednesdays or Fridays, instead of that message I would see a dialog box that indicated that the backup was running. In those cases, it seemed that I had to either click Cancel (and thereby lose the job I had been creating) or simply wait for the job to be done (not what I want to do in the middle of the day).This all happened in the morning, so I'm baffled as to why the jobs would be launched immediately even if (as was the case for the Wednesday job) it was the right day of the week, since the run time was always specified as 11:00 PM. Does anyone have a clue as to why this is happening, or how I can avoid it? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-24 : 12:24:02
|
| How are you scheduling these jobs? This should not happen. Are you going to jobs under SQL Server Agent in Enterprise Manager and right clicking then New Job? If so, there is something wrong with what you are selecting.Tara |
 |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-03-24 : 13:22:26
|
| My guess is that your using Backup wizard in E.M. instead of the Database Maintenance Plan Wizard.JimUsers <> Logic |
|
|
|
|
|
|
why new backup job launches immediately