Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 300455

Writing queries to request or change information stored in a database or other information management system. Questions should include table and index definitions, sample data, expected output, and a tag for the specific system (e.g. MySQL, PostgreSQL, Oracle, SQL Server, MongoDB).

0 votes

sql server query to show the running jobs - what about the steps of the job?

I wrote the following query to list whole jobs duration and dates, times. declare @job_id uniqueidentifier ='52B11298-F14A-436E-9313-2DE54B78B37F' select j.name Job_Name, h.run_date [Date], h.run_time … When you refresh the query, the job duration proceeds. After the job complation the result is as follows. …
Fevzi Kartal's user avatar
1 vote

script to change the schedule of a job, it needs to find the schedule associated with the job

USE msdb; GO declare @jname sysname='DatabaseBackup - SYSTEM_DATABASES - FULL' declare @sname nvarchar(128) set @sname=(select s.name from sysjobs j inner join sysjobschedules js on j.job_id = …
Fevzi Kartal's user avatar