Well, here is an odd error message that had me looking in the wrong direction for a few minutes. While attempting to resolve an asynchronous database mirroring issue on a SQL Server 2012 Enterprise instance running on Windows 2008 R2
The following script when run on your SQL Server instance will show all schedules that are disabled but more importantly will show those schedules that have jobs associated with them.
The following is a small T-SQL script that I frequently use to show the jobs on an instance of SQL that are enabled but are not associated with any type of schedule;
I recently came across this minor issue while attempting to get an SSIS package to run via the command prompt. It took me a couple of hours and quite honestly don’t recall how I stumbled upon the solution.