Log in | Register

SQL Server Agent Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education SQL Server Agent Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

SQL Server Agent

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

SQL Agent Job Error CMDEXEC subsystem failed to load

We have been recently migrating a lot of physical clusters to virtual. The quickest way to move sql agent jobs was to restore MSDB database. To validate if jobs were in order we executed our System Backup job and surprisingly it went in ‘Suspended’ mode. Investigation for the failed job revealed:

[LOG] Step 1 of job ‘DatabaseBackup […]

SQL Server Job Performing Completion Actions Blocked: An Interesting case

Hello,

Recently we had an issue with chain blocking and most of the jobs are complete but do not finish. When observed in Job Activity Monitor most of the jobs say “SQL Server Job Performing Completion Actions”. This doesn’t give you any idea about what is the job doing in the backend to finish. When […]

SQL Server – SQL Agent Proxies

I have seen many DBAs arguing on xp_cmdshell as a security risk or a bad practice. And on a strong recommendation of a DBA Architect VENDOR your company has chosen to disable xp_cmdshell for you environment and restrict all access for all accounts on SQL Server to SQL itself. Unfortunately you are needed to […]

SQL Server Using Powershell to Move SQL Agent Jobs Across Instances

Migrating jobs from one server to other can be easily done with powershell. Let’s look into the script. At first, include reference to the relevant SMO assemblies and then create the source and destination sql instance objects.

The variable $sourceserver specifies the source server instance where as the variable $destinationserver specifies the destination server.The next […]

Newsletter_Footer