• Replies 2 replies
  • Subscribers 336 subscribers
  • Views 64 views
  • Users 0 members are here
Related

KA Extract Jobs in SSMS

Frances O'Connell
$organization

Hi everyone - in our environment, scheduled extractions create Jobs in SSMS (I assume this is normal?).  Can anyone share what they do with these jobs?  Do you delete them from SSMS?

Thanks,

Frannie

Parents
  • Former Member
    Former Member $organization

    Hi Frannie,

    I created a job that runs nightly to deleted these KA Extract jobs. From what I have gleaned -- these jobs are only created when the extraction fails. So, they are really not needed.

     

    Here is the t-sql:

    DECLARE @jobId BINARY(16);

    WHILE (1 = 1)
    BEGIN
        SET @jobId = NULL;
        SELECT TOP 1 @jobId = job_id
        FROM msdb.dbo.sysjobs
        WHERE (name LIKE N'KA Extract %');

        IF @@ROWCOUNT = 0
            BREAK;

        IF (@jobId IS NOT NULL)
            EXEC msdb.dbo.sp_delete_job @jobId;
    END;

     

    Debbie

     

     

Reply
  • Former Member
    Former Member $organization

    Hi Frannie,

    I created a job that runs nightly to deleted these KA Extract jobs. From what I have gleaned -- these jobs are only created when the extraction fails. So, they are really not needed.

     

    Here is the t-sql:

    DECLARE @jobId BINARY(16);

    WHILE (1 = 1)
    BEGIN
        SET @jobId = NULL;
        SELECT TOP 1 @jobId = job_id
        FROM msdb.dbo.sysjobs
        WHERE (name LIKE N'KA Extract %');

        IF @@ROWCOUNT = 0
            BREAK;

        IF (@jobId IS NOT NULL)
            EXEC msdb.dbo.sp_delete_job @jobId;
    END;

     

    Debbie

     

     

Children
No Data