Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

basic backup problem - scheduled jobs don't stick

Status
Not open for further replies.
Mar 18, 2003
6
0
0
US
logging onto my w2k svr running sql 2k, i right click on the dbase and via all tasks i setup a backup job. if the job runs immediately no prob. if the job has a schedule, it disappears when i leave and go back into the interface to check it....anyone know what's up with that?
 
I had the same problem sept with dts packages
would work when I ran them but if I shedualed them no luck.
The problem was the sqlserver agent was not running as a domain acount. was set to a local nt account. I changes this in the service managager and works like a charm.
Check event viewer also it should tell you more stuff too
cheers
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top