Friday, February 24, 2012

How to know the User who disabled a Job?

Hi all,

Is there any way I can know who Disabled a Job??

bye.Hi

I don't think there is anywhere that stores this.

John

"sasi" <vardhansasi@.gmail.com> wrote in message
news:1135868860.566217.105180@.o13g2000cwo.googlegr oups.com...
> Hi all,
> Is there any way I can know who Disabled a Job??
> bye.|||Make use of Profiler

Madhivanan|||How can I use Profiler to find the user who disabled the job?

Can u b more descriptive or lead to some reference.|||Hi

Check out the code from the following post and create a stored procedure to
do this http://tinyurl.com/bu2f9. You may want to add your own filter. Also
lookup sp_procoption in Books Online to make the procedure run at startup.

John

"sasi" <vardhansasi@.gmail.com> wrote in message
news:1136450853.470529.143800@.g49g2000cwa.googlegr oups.com...
> How can I use Profiler to find the user who disabled the job?
> Can u b more descriptive or lead to some reference.

No comments:

Post a Comment