title: SQL Server 2008R2: How to find what query/procedure a sql job agent is running?
body: <p>I have a mssql database with some sql job agents for backing up the database. This was done by someone before me and i need to find the script that is being run by the job agent, so i can find out where the database backups are being stored. is there any way i can find this script or procedure that the job agent is executing ? Just to let you know i am not a dba and i have very little knowledge of the db management, so please try to explain as if your explaining to a newbie. </p>