SQL Server Agent Schedule Decoder
This script will break job schedules down into a readable format (msdb.dbo.sysschedules)
2010-01-06 (first published: 2009-12-16)
1,967 reads
Agent jobs
Script all the jobs on a SQL server 2005 and apply them in SQL 2008
The script will produce a Drop/Create script for all the jobs existing on the server. Instead of scripting them individually.
The output script will also have schedules scripted out
2009-09-18 (first published: 2009-09-08)
7,272 reads
Execute SQL job through batch file
This article will show you how you can execute a SQL job with one click, allowing anyone to do this. Author Divya Agrawal shows a technique to let other users run jobs that do things such as perform a backup with a batch file.
2009-06-05
22,612 reads
What SQL JOb's are running on 2005 Server
This script returns the information of all SQL Jobs that are running on the server with the latest status.
2009-05-01 (first published: 2009-04-08)
1,626 reads
Job History with Timeline
Similar to many other Job History scripts, but unique in that it has a timeline.
2010-06-01 (first published: 2009-04-03)
3,327 reads
2008-12-31
2,909 reads
2008-10-23 (first published: 2008-08-24)
1,917 reads
2008-03-27
5,125 reads
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
BCA KCU PANAKKUKANG Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi...
BCA KCU MAKASSAR Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Ahmad Yani No.31, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan...
BCA KCU AMBON Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers