SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 When was alert created?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

denis_the_thief
Aged Yak Warrior

Canada
591 Posts

Posted - 03/26/2013 :  14:17:09  Show Profile  Reply with Quote
We have this alert. The Alert is associated to a job (i.e. the response is set to a job).

Is there anyway to find out when this job was created? I looked at sysalerts but I did not see much there. I couldn't get much information from the job history since it was set at 100 max and this was maxed out.

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 03/26/2013 :  14:25:46  Show Profile  Visit russell's Homepage  Reply with Quote
use msdb;
go
select date_created from sysjobs where name = 'name of job here';
Go to Top of Page

denis_the_thief
Aged Yak Warrior

Canada
591 Posts

Posted - 03/26/2013 :  15:52:19  Show Profile  Reply with Quote
Thanks. But I guess that is the date the Job was created, I am wondering when the alert was created.

What I am wondering is if the alert existed last week. Since the job the alert is associated to is maxed to 100 entries in the job history, it is only going back a day and a bit. Each entry in the log is saying the Alert triggered the job but since it happened about 100 times in the last day or so, I can't tell if this was going on last week. Just now, I upped the max history job records to 500 per job so that will help going forward.
Go to Top of Page

denis_the_thief
Aged Yak Warrior

Canada
591 Posts

Posted - 03/26/2013 :  16:02:37  Show Profile  Reply with Quote
I see my O.P. says when this "job" was created. Sorry, I meant Alert.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 03/26/2013 :  17:26:51  Show Profile  Visit russell's Homepage  Reply with Quote
No way I know of for certain.

Might check the default trace to see if an alert was created the last few days, but I'm not altogether sure that is captured.

If it calls a SQL Agent job, then seems somewhat likely the job was created to support the alert.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000