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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 regarding creating jobs

Author  Topic 

alakiran
Starting Member

14 Posts

Posted - 2008-01-22 : 01:28:37
Hi Everyone,
Can anybody tell me how to create a job which tells me when was the SQL server agent was last started?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2008-01-22 : 10:57:56
this information is in the event logs
Go to Top of Page

alakiran
Starting Member

14 Posts

Posted - 2008-01-22 : 12:51:55
quote:
Originally posted by russell

this information is in the event logs




Tnx Russell,I am new to this field,can you briefly explain me how to create it?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-22 : 22:28:03
Why need sql job for this? Just check sql agent error log.
Go to Top of Page

alakiran
Starting Member

14 Posts

Posted - 2008-01-23 : 02:31:14
I got the answer,Thanks alot guys
Go to Top of Page
   

- Advertisement -