Activity overview
Latest activity by Aleksandar
Unfortunately agent jobs are stored in terms of steps. One of the columns in the table is the Job ID, however you have to do a join with the sysjobs table to get its actual name. ive done this below: MERGE JOBS
USING
(
Select
msdb.dbo.sysjobs.name AS [job_name],
msdb.dbo.sysjobsteps.step_id AS [step_no],
msdb.dbo.sysjobsteps.step_name AS [step_name],
msdb.dbo.sysjobsteps.command AS [step_details],
msdb.dbo.sysjobsteps.step_uid AS [step_uid]
From
msdb.dbo.sysjobs
JOIN msdb.dbo.sysjobsteps
ON msdb.dbo.sysjobs.job_id=msdb.dbo.sysjobsteps.job_id
) AS TEMP
ON
( JOBS.STEP_UID = TEMP.step_uid
)
WHEN MATCHED AND -- If it exists AND has changes
(
JOBS.JOB_NAME <> TEMP.job_name OR
JOBS.STEP_NO <> TEMP.step_no OR
JOBS.STEP_NAME <> TEMP.step_name OR
JOBS.STEP_DETAILS <> TEMP.step_details
)
THEN
UPDATE Set
JOBS.JOB_NAME = TEMP.job_name,
JOBS.STEP_NO = TEMP.step_no,
JOBS.STEP_NAME = TEMP.step_name,
JOBS.STEP_DETAILS = TEMP.step_details,
JOBS.STEP_UID = TEMP.step_uid
WHEN NOT MATCHED AND TEMP.step_uid IS NOT NULL THEN -- New files
INSERT (JOB_NAME, STEP_NO, STEP_NAME, STEP_DETAILS, STEP_UID)
VALUES (TEMP.job_name, TEMP.step_no,TEMP.step_name,TEMP.step_details,TEMP.step_uid)
WHEN NOT MATCHED BY SOURCE THEN
DELETE
;
Im new to sql so hopefully that makes sense and answers your question in some respect at least [image] / comments
Unfortunately agent jobs are stored in terms of steps. One of the columns in the table is the Job ID, however you have to do a join with the sysjobs table to get its actual name. ive done this belo...
Just had the bright idea that i could just copy the data from that table to some other database. I personally dont need version control on the system databases anymore but i imagine for some reason, someone out there might. / comments
Just had the bright idea that i could just copy the data from that table to some other database. I personally dont need version control on the system databases anymore but i imagine for some reason...
System Databases
Had a quick search and couldnt find any info on this, but:
Is there any way to put system databases under version control? In my case i just wish to put MSDB under version control and filter out ev...
yep, throttling it back is nice and easy, but turning off polling is even easier [image]
see here: http://www.red-gate.com/MessageBoard/vi ... hp?t=12837 / comments
yep, throttling it back is nice and easy, but turning off polling is even easier
see here:http://www.red-gate.com/MessageBoard/vi ... hp?t=12837
Tempdb use
We've been monitoring how much tempdb space RGSSC uses over a couple of days and it looks like it may be an issue. Over the space of 6 hours, when we had one client open, it seemed to reach 1.4gb a...
First off should probably note im using shared db dev model.
I used SQL compare to roll back to a prevision version (from V80->v50). Source Control showed NO blue dots anywhere so i thought it had done nothing and closed/reopened SSMS. I wasnt prompted to update(get latest) the objects nor that there were any changes (i had no SSC indicator on bottom left of the DB icon at all).
I checked from a different account and SSC was v80 but had all of the objects were from v50, ie, it had been rolled back.
It seems to have overwritten v80 with the contents of v50 in Source Control.
From what your saying i should need to commit the rollback and that makes a hell of a lot more sense. Maybe this was just a bug/glitch. / comments
First off should probably note im using shared db dev model.
I used SQL compare to roll back to a prevision version (from V80->v50). Source Control showed NO blue dots anywhere so i thought it had ...
Source control integration issues
After playing around with SQL Source Control and SQL Compare I just want some confirmation on an issue.
While using Compare to rollback to a previous version, i noticed that this action is not comm...