<div>
you can check in the Log or.......... u can write an audit &nbsp;trigger on the table sysjobs <br />

</div>


you can check in the Log or.......... u can write an audit  trigger on the table sysjobs


<div>
If you have not implemented sysjobs trigger so far and msdb database transaction log backup than right now there is no change to look at it if it has been done in past but you can do it as a future precautions 
</div>


If you have not implemented sysjobs trigger so far and msdb database transaction log backup than right now there is no change to look at it if it has been done in past but you can do it as a future precautions

<div>
Thanks for all your replys. I have not been doing transactional log backups on the msdb database. I will from now on though. Thanks for the info about triggers etc, looks good. Cheers Craig
</div>


Thanks for all your replys. I have not been doing transactional log backups on the msdb database. I will from now on though. Thanks for the info about triggers etc, looks good. Cheers Craig

<div>
<div class="content wysiwyg-content">
Hi,<br />
One of our admins has deleted a SQL Job from our SQL 2005 Server (Std).<br />
I would like to know if it is possible to find out which admin deleted the job and if also possible when? <br />
Regards Craig
</div>
</div>


Hi,
One of our admins has deleted a SQL Job from our SQL 2005 Server (Std).
I would like to know if it is possible to find out which admin deleted the job and if also possible when? 
Regards Craig

Find out who deleted SQL 2005 Job

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.