Gathering failed job history using power shell

How to use this powershell script:    – Launch SQL Server PowerShell ( Start -> Run -> sqlps.exe)    – Copy the following powershell script and save to file (Ex c:\JobHistory.ps1)    – in SQL powershell window, type in script file path ( Ex: c:\JobHistory.ps1) to run the scriptNote: replace “machine\instance” with       default instance – machinename\DEFAULT      named instance –…

0

Automatic backups, one per day, and with different backup file names

  SQL Agent can be used to perform scheduled backup job to backup a database to a unique file name that is constructed based on the system date.  To construct a unique file name, you can use SQL Agent’s token substitution mechanism. You can read more about token substitution  at  http://msdn.microsoft.com/en-us/library/ms175575.aspx   Here is the…