We have a SQL Agent job that runs a stored procedure. Is it possible for the stored procedure to programmatically determine the name of the SQL Agent job that executed it? (Without the agent job passing its name to the procedure through
a parameter.) How would you do it?
View Complete Post