Sethu's blog

dev@sqlservr.microsoft

Browse by Tags

Tagged Content List
  • Blog Post: Auditing SQL Agent job creation and deletion

    SQL Agent jobs are added / removed using stored procedure interface sp_add_job and sp_delete_job. Customers have asked us how we could track user who has created a job / deleted a specific job. You could accomplish this using SQL Server Auditing feature. You can turn on Auditing to track and log stored...
  • Blog Post: Starting Jobs in Powershell using Job Name

    http://blogs.msdn.com/b/sqlagent/archive/2010/12/29/starting-jobs-in-powershell-using-job-name.aspx This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
  • Blog Post: Scheduled Policy Evaluation on multiple servers using MSX/ TSX in SQL Agent

    One of our customer was looking for ways to schedule a policy evaluation on multiple servers using their existing MSX/TSX infrastructure. I thought it would be better to blog an article that could help others looking for similar information http://blogs.msdn.com/b/sqlagent/archive/2010/11/19/scheduled...
  • Blog Post: Turning on Verbose logging in SQL Agent

    Turning on Verbose logging in SQL Agent This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
  • Blog Post: Create a database backup job using SQL Server Management Studio

    SQL Server Management Studio can be used to create a database backup job to backup an user database. Link This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
  • Blog Post: Create SQL Agent job using SMO

    # Powershell script to create a new Agent job and list the job using JobCollection # Inspects error collection and prints all inner exception function CheckForErrors { $errorsReported = $False if ( $Error . Count - ne 0 ) { write-host "******************************" write-host "Errors:" , $Error . Count...
Page 1 of 1 (6 items)