This post is to show you how we can categorize jobs created inside SQL Server agent. In practice, most often you would come across OLAP systems where lot of back end activity will be happening through sql agent jobs that…
Get sql agent jobs that are dependent on an object
Recently we had come across a scenario where we needed to find list of sql jobs which are dependent on an object (a stored procedure in our case). We had a generic procedure which was used by several sql agent…
Running SSIS packages in 32 bit mode in 64 bit server
The impetus for this blog is recent issue faced by use in running SSIS package from a job created in SQL Server agent. The package was locally developed and tested fine. After deploying package to server and trying to run…
DBIDs are not consistent always…
Today one of fellow developers asked me a question on db_id which prompted me to do some analysis and find out the discovery which I’m sharing here. Database ids will not always point to same database! Before you get fully…
Recursive delete from parent child tables
Quite often there are cases where we will have set of tables linked by means of foreign key relationships. Deleting from one among such tables can be a real pain especially when it having lots of direct and indirect dependencies…