question

uday.madhapur avatar image
uday.madhapur asked

Multi windows server Reboottime

Hi, I created servers,lastboottime tables in DBA_DB database ,in first table there is a column that is servers.In second table there is a one column that is lastboottime. I created one job(windowslastboottime) in this step1 truncate lastboottime(table). step2. exec that powershell script. after this when you execute query like select * from lastboottime your going to get servers lastboottime, but my concern is servers name and lastboottime needed Thanks
sql-server-2008-r2powershellwindows
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

So, what is your question?
0 Likes 0 ·
I need multi windows server reboot time,through powershell scripting.
0 Likes 0 ·
yes i know,i am not able to prepare a script for that two columns
0 Likes 0 ·
DenisT avatar image
DenisT answered
Why do you need 2 tables? Insert into one table with 2 columns (server_name,last_boot_time) then you won't have this problem.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Willjoe2442 avatar image
Willjoe2442 answered

How long does a server reboot take? A: Depending on the server and how many running processes are there in the background, the time it takes for your machine to reboot may vary. You should expect anything from a couple of minutes to 10-15 minutes when a forceful restart is initiated.


Regards,

Will

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.