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.
| Author |
Topic |
|
opowell
Starting Member
12 Posts |
 Posted - 2010-04-28 : 14:59:04
|
I have been asked to send notifications when the following events happen.a job is excuteda job is addeda job is deletedCan this be done from a set of triggers? Or is there a simplier way? |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-04-29 : 00:05:24
|
quote:
Originally posted by opowell
I have been asked to send notifications when the following events happen.a job is excuteda job is addeda job is deletedCan this be done from a set of triggers? Or is there a simplier way?
You can use "notification" in the job set up to perform the action when the job completes.I don't think there is any DDL trigger for JobAdded and JobDeleted.Regards,BohraI am here to learn from Masters and help new bees in learning. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-04-29 : 00:13:30
|
Jobs are stored in MSDB database.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
|
|
|
Reporting on Jobs in SQL Server