You bet.

".. until it reaches level 32 ..."

It sounds like playing computer game: "SQL server advanture"

It has 32 levels, each is more difficalt.

(...

Thank you.

It trigger working fine.

 It works even nested triggers set enabled!?

Thanks

Thank you very much.

Going to try it tomorrow morning.

Have a good night.

Leon

Thank you everybody,

Using the alerts to start job - is nice and elegant solution to allow the user to execute job using rights, he realy does not have.

Great! Thank you.

You are right.

But, I have in the job with a few dependant steps, executing T-SQL and CmdExe commands..

Of course, everything could be done in store proc, but it seemce easier...

Thank you.

That what I gona do.

But would it make sence to have a job level permission?

Leon

User will start job from the batch, so I would like go allow him to execute only ONE particular job.

Can it be done?

Thank you