My company has system updates that go on at night and re-boot my amature sql server. When I come in in the morning I have to log in and re-do all the jobs that were supposed to have ran. Is there a way to have the jobs run even though i'm not logged in?
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!
Company system updates rebooting SQL server
- Thread starter Tapew0rm
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
- 0
- 36
If the SQL Agent service is running then the jobs will run. If the server is rebooted any jobs which should have started while the server was done will need to be restarted manually.
You don't need to be logged into the server for the jobs to run.
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
My Blog
You don't need to be logged into the server for the jobs to run.
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
My Blog
- Status
Similar threads
- Question
