I've set up SQL Server Agent job to run about 20 execs statements in a row but it does't seem to run through.
E.g The job contains
exec sp_unfile_report 123
exec sp_unfile_report 456
exec sp_unfile_report 789
and repeats for 17 more times.
I set scheduled the SQL job last night which ran successfully with not error but I don't think is ran properly as the job only took 5 seconds when I would expect it to take at least 30 minutes to complete.
Many thanks if anyone can advise
P.s Thanks to everyone for helping me in my past Topics that I've posted.