I have two nightly jobs that always show up as 'failed' after they have run automatically the night before (1 AM), but when I run them by hand they succeed. In più, when successful they each take between 15 and 20 seconds, but they run for slightly over a minute when they fail.
In the job history one is failing with this message
SQL Server does not exist or access denied. [SQLSTATE 42000] (Error 17). The step failed.
Does this refer to a remote server? I hope not because the stored procedure doesn't reference any remote server objects.
The other is failing, but the error message is unintelligible. It's comprised of the PRINT statements in the sp, with '... The step failed.' At the end.
An ideas about what might be happening here?