Viewing 15 posts - 16 through 30 (of 38 total)
ok i got it to work by replacing FOR UPDATE to AFTER UPDATE, INSERT, DELETE however the email i get sucks this is all i get New job creation or job modification alert
here is...
November 28, 2017 at 8:55 am
i was thinking this
use msdb
go
CREATE TRIGGER [dbo].[jobChecker2]
ON sysjobs
FOR UPDATE AS
SET NOCOUNT ON
-- # DECLARE VARIABLES # --
DECLARE @username VARCHAR(50),
@hostName VARCHAR(50),
@jobName VARCHAR(100),
@newEnabled INT,
@oldEnabled INT,
...
November 28, 2017 at 8:32 am
thats my problem not sure what to put in
November 28, 2017 at 8:21 am
i am getting emails just fine for enable and disable jobs but not for add or delete not sure how to code this
use msdb
go
CREATE TRIGGER [dbo].[jobChecker2]
ON sysjobs
FOR UPDATE AS
November 28, 2017 at 8:10 am
I am a consultant and the client does not have that. This will work for what I need. Thank you for all your help
November 27, 2017 at 11:14 am
i did that and it works just thought there would be a cleaner way to see it like in the gui
guess if i want to automate this it will...
November 27, 2017 at 10:31 am
that works thanks much but what is best way to review bacpac file to see what is in it
November 27, 2017 at 10:19 am
I know about that and it works well however I want to be able to automate this and run a schema extract like once a week
November 27, 2017 at 8:19 am
this trigger thing is just a big pain for this. Is there a way with standard alerts to be notified for a disable, enable, and schedule change
November 27, 2017 at 6:32 am
i agree and wanted to look at scripting from database
is there anyway i can do that
this place has a lot of issues
November 22, 2017 at 10:28 am
i am ok with how it works i just cant figure out the logic to add for job added job deleted or schedule changed
November 22, 2017 at 8:41 am
here is code
USE [msdb]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[jobChecker]
ON sysjobs
FOR UPDATE AS
SET NOCOUNT ON
-- # DECLARE VARIABLES # --
DECLARE @username VARCHAR(50),
@hostName VARCHAR(50),
@jobName VARCHAR(100),
...
November 22, 2017 at 8:20 am
was told the server guys worry about the physical disk and i did not have to worry about that
we will see
November 22, 2017 at 7:19 am
sorry here is code
CREATE PROCEDURE usp_Sizing @Granularity VARCHAR(10) = NULL, @Database_Name sysname = NULL AS
DECLARE @sql VARCHAR(5000)
IF EXISTS (SELECT NAME FROM tempdb..sysobjects WHERE NAME = '##Results')
BEGIN
DROP TABLE ##Results
END
CREATE TABLE ##Results ([Database Name] sysname,
[File Name] sysname,
[Physical Name] NVARCHAR(260),
[File Type] VARCHAR(4),
[Total Size in Mb] INT,
[Available Space...
November 21, 2017 at 10:11 am
Viewing 15 posts - 16 through 30 (of 38 total)