Forum Replies Created

Viewing 15 posts - 16 through 30 (of 38 total)

  • RE: Trigger to notify when mssql job is disabled

    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...

  • RE: Trigger to notify when mssql job is disabled

    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,
                 ...

  • RE: Trigger to notify when mssql job is disabled

    thats my problem not sure what to put in

  • RE: Trigger to notify when mssql job is disabled

    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

  • RE: MSSQL Schema Export Only

    I am a consultant and the client does not have that. This will work for what I need. Thank you for all your help

  • RE: MSSQL Schema Export Only

    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...

  • RE: MSSQL Schema Export Only

    that works thanks much but what is best way to review bacpac file to see what is in it

  • RE: MSSQL Schema Export Only

    not familiar with that how does it work

  • RE: MSSQL Schema Export Only

    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

  • RE: Trigger to notify when mssql job is disabled

    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

  • RE: trying to edit a stored procedure

    i agree and wanted to look at scripting from database
    is there anyway i can do that
    this place has a lot of issues

  • RE: Trigger to notify when mssql job is disabled

    i am ok with how it works i just cant figure out the logic to add for job added job deleted or schedule changed

  • RE: Trigger to notify when mssql job is disabled

    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),
                 ...

  • RE: trying to edit a stored procedure

    was told the server guys worry about the physical disk and i did not have to worry about that
    we will see

  • RE: monitor file size

    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...

Viewing 15 posts - 16 through 30 (of 38 total)