Unable to access SSIS package - social.msdn.microsoft.com
Sep 4, 2007 · I (actually my DBA did it) have created an SSIS package in MS SQL Server 2005. It can be found under Integration Services under: Stored Packages MSDB VisBridges ExportTime
SQL job creation/modification/deletion auditing?
Mar 11, 2019 · Just try Createtrigger tra_sysjobs on msdb.dbo.sysjobs afterinsert , update , deleteDeclare @Body1 nvarchar (max) Select @Body1 = 'SQL Server Job Name: ' + name + ' …
SQL Azure + trigger + send email - social.msdn.microsoft.com
Sep 20, 2013 · Reference to database and/or server name in 'msdb.dbo.sp_send_dbmail' is not supported in this version of SQL Server.
Can we create index on msdb database for backupset objects
Oct 24, 2013 · I am using sql server 2008 with sp3. I want to confirm whether we can create index on msdb database for backupset objects or not. what is the purpose of this ???
how to disable SQL Server Agent Jobs using T-SQL
Oct 4, 2011 · CREATE PROCEDURE Utilities_UpdateJobProperties -- The job SETS a property VALUE FOR a given job -- Name OF the job TO be MODIFY, IF null ALL the jobs IN the …
How to configure and automate Log shipping through scripting
Jul 3, 2014 · -- Execute the following statements at the Primary to configure Log Shipping -- for the database [primary\instance1]. [mydb], -- The script needs to be run at the Primary in the …
'DatabaseMail process is shutting down'
May 27, 2016 · Based on my research, the above issue could be caused by that MSDB is growing as database mail is not working properly, which makes the drive lack of free space. Please …
needing to restore msdb to another server to save dts and jobs
Sep 25, 2008 · Before using the script dont forget to change the new servername in the query If you prefer to copy DTS alone and not to restore msdb then copy the table …
log file for database 'msdb' is not available
Sep 20, 2012 · Somebody or something apparently is depeting the ldf file for your msdb database. I suggest you use OS functionality to monitor what or who does that. happens outside of SQL …
Msdb corrupted on sql server - social.msdn.microsoft.com
Jan 17, 2014 · MSDB system database files is used for scheduling alerts and jobs. since you mention that it got corrupted you can recover it by using a dedicated Database Recovery …