Have Geek Brain

Select "Job Statements"

I have inherited several jobs and I am trying to understand why the choice of operators will be in their steps. I would have thought that select statements would be meaningless in an automatic job that displays nothing to the end user.

+2


a source to share


1 answer


It's hard to see why without seeing the code, but I can guess ...

Perhaps it's SELECT ... INTO ... where the results are stored in another table.



Another alternative might be to simply check that the service is running correctly. If the selection fails, an exception can be thrown and this can be detected elsewhere to notify someone of the problem.

+1


a source






More articles:


All Articles