I have a process where I check for SQL Server agent job execution status making sure all the jobs in question have their last run for the given date completed reporting either success or failure. Based on the outcome of the last run I either execute downstream jobs on success or abort on failure. I have this process which waits for a minute and then loops through all the specified jobs until all are complete.

I have a process where I check for SQL Server agent job execution status making sure all the jobs in question have their last run for the given date completed reporting either success or failure. Based on the outcome of the last run I either execute downstream jobs on success or abort on failure. I have this process which waits for a minute and then loops through all the specified jobs until all are complete.

I have a process where I check for SQL Server agent job execution status making sure all the jobs in question have their last run for the given date completed reporting either success or failure. Based on the outcome of the last run I either execute downstream jobs on success or abort on failure. I have this process which waits for a minute and then loops through all the specified jobs until all are complete.

I moved a stored procedure from one database to another and that went fine. I then went to run it and got these errors:

I’m very much struggling to put into words what I’m trying to do, but hoping the examples suffice.