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!

Register Log in
  • Congratulations wOOdy-Soft 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

Status
Not open for further replies.
Tapew0rm

Tapew0rm

Technical User
Jan 25, 2002
13
US
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?
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MathiasB
  • Question
Parameterised sql server query
Replies
8
Views
408
Chriss Miller
C
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
769
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
960
pjw001
pjw001
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
556
Chris Miller
Chris Miller
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
644
Mike Lewis
Mike Lewis

Part and Inventory Search

Sponsor

Back
Top