| A community of more than 1,600,000 database professionals and growing |
| | | First Class Jobs I was looking through the forums the other day and noticed that someone wanted to track changes to the Agent jobs on their instance. However, they couldn't find a DDL trigger to capture the changes to a job. That's because a job is really data in a table, in dbo.sysjobs, dbo.sysjobsteps, etc. in msdb. To capture changes to a particular job, one would need a DML trigger that captures the insert/update/delete actions on these tables. You could also use XE, Audit, or some other feature that can track data changes in the msdb tables. I'm not sure that makes sense to me. This week I'm wondering if any of you feel that SQL Agent jobs aren't well integrated into SQL Server. Do you think that jobs should be a first class database citizen and managed with CREATE JOB, ALTER JOB, etc. DDL commands? I think so. In fact, this would be the first step (in my opinion), towards getting jobs as a more useful database work process. Let's have a job system that handles automated mechanisms inside the database as actual objects we can manage, set permissions on, and control just as we do other objects. Let's treat these objects for what they are, actual items in SQL Server that should be objects. Could this be implemented? Sure. In fact, I think this might be one of the best ways to start containing jobs inside of a database. Make them a first class object inside a database. We can use msdb as the container for instance wide jobs. Then any sort of scheduler, including SQL Agent, could use an API to pick up the code from within the database and execute it however they determine is best. I don't think this is simple or easy, but it's possible. It would take some engineering effort from Microsoft, but I'm confident they could build a great ssytem. Making a job a first class citizen could help us control and simplify everything to security to transfer of the work from instance to instance. When the database moves, so does all the work associated with it. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.1MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | | | | How can you help your team write better, shareable SQL faster? Find out by discovering 15 Super SQL Tips from Microsoft MVPs and other SQL Server experts. Using SQL Prompt to write, refactor, and share SQL, they show how it strips away the repetition of coding and standardizes it everywhere. View the tips and dow... |
| | | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more. |
| | | | SQL in the City Streamed Register now for Redgate's free virtual event offering a wealth of SQL Server sessions for you to livestream on December 14 and 15. Find out more and register. |
|
|
|
| | | | | Frank A. Banin from SQLServerCentral.com As the de-facto big data processing and analytics engine, the Hadoop ecosystem is also leading the way in powering Internet of Things (IOT) More » |
| | Additional Articles from SimpleTalk Can there be true separation of concerns with MVC? Not entirely, especially when Angular's templates allow you to so much flexibility; but there is a great deal to be gained from following guidelines to ensure that all business logic is performed in the code-behind as directed by the controller or its delegate, and that all operations on the model are done in the controller: Michael Sorens explains the four essential guidelines for an easily-maintained system. More » |
| | Redgate invites you to participate in a survey to uncover rates of adoption of DevOps practices among Microsoft SQL Server database users. The survey will take between 5 and 10 minutes to complete. All respondents who provide a valid email address will be sent a copy of the research report when available, as well as being entered into a prize draw to win a $250 Amazon gift card. More » |
| | Steve Jones from SQLServerCentral Blogs I’ve been trying to get used to using the dbatools cmdlets in PoSh. They help me learn some PowerShell, but... More » |
| | Tim Mitchell from SQLServerCentral Blogs There are several ways to execute SSIS packages that have been deployed to the SSIS catalog, and my favorite way... More » |
|
|
| | | Today's Question (by Steve Jones): What is the name of the protocol that the SQL Server browser uses to communicate? |
Think you know the answer? Click here, and find out if you are right. We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: SQL Browser. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS. Pick up your copy of this great book from MVP Glenn Berry at Amazon today. |
|
|
|
|
|
| Yesterday's Question of the Day |
| | |
| | | | Rinu George Philip from SQLServerCentral.com Here's a script, for killing a SPIDs against a particular database, here am using BIN as the database. We have to change the name of the database accordingly. This script can be used when we need to check for blockings on a database and helpful, when we have to restore a database especially when the database is in use while restore. --------------------------------------------------------------- More »
|
|
|
| Database Pros Who Need Your Help |
| | Here's a few of the new posts today on the forums. To see more, visit the forums. Search query based on four separate parameters. - Hello all, After searching for possible solutions, I haven't found anything that provides me with what I'm after. I'm fairly new... Is it Possible to Query Rows by Page ID? - Hey, does anyone know if there's some undocumented feature that would allow you to query a table by FileID/PageID? Something like... possible combinations for all rows in table - I have a table having three column Name Value1 Value2 Value3 A 1 2 3 B 4 5 1 C 2 3 1 I want... Best and economical enterprise monitoring tool - Friends, I have used Microsoft SCOM, HP Openview, BMC Patrol and a few more tools to monitor my database infrastructure..But currently,... Only perform cleanup with Ola Hallengren's maintenance scripts - Hi, Has anyone been able to successfully use Ola Hallengren's maintenance scripts to only clean up old backups and not take... Is there a way to extract only credit card numbers from text - i have below sample data, i try to extract valid credit card data. But i was not able to do... How to drop temp table created by somebody else? - I want to drop a temp table created by somebody else how would I go about doing this? I see... Select continual date ranges from a list that overlaps - Hi There, need some help. I have list of prices and the dates they are valid from and to. For Example: Date... Multiple files in Primary Filegroup - I recently came across a large database (1 TB) that had multiple data files spread out among several drives. I... TempDb File Sizing - I have inherited an infrastructure in which the tempdb is set up with multiple files, 8 all told (mdf and... Accessing lookup tables - Hi I'm creating sql views that access lookup tables to return the full description from a table that holds a... SQL Password Policy and Expiration - We are in the discussion of enforcing password policy to our SQL accounts so that none of the accounts can... SQL Query - I'm trying to make a script where I can add leading zeros to numbers less than 7. I have it... A scenario where SQL Server doesn't seem to help - Hi We have a scenario, where busniess users are presented with a screen with 20+ fields. They can choose any number... Looking for a smarter script to do this query - I am stuck on a very repetitive query now, I wonder if anyone can help me on figuring out a... Best way to automate running adhoc scripts? - Hello, Just started a new DBA position. I am seeing things that seriously need some attention. I would rather not do... Dynamic pivot table and SSRS - I need to create a report on hospital discharges over a rolling 12 month period. The data should be pivoted... OpenRowset for CSV File - So earlier, I am on the verge of creating a code that would import a CSV file that is machine... SSIS Excel import error - The situation is: Server A: runs alle the ssis jobs. Excel is located on a fileserver. Connection string Excel: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\Fileserver\somewehre\Excelfile.xlsx;Extended Properties="EXCEL 12.0 XML;HDR=YES"; The... Output Full Result Set to a Table - Article - Does anyone know of a good article on Outputting a Full Result Set to a Table? I have the SQL Task... |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. | This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here. | This transmission is ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
