Viewing 4 posts - 16 through 19 (of 19 total)
In addition to anthony.green, you'll probably need a while loop where you'll have WAITFOR that would make delays between job status checks. Don't forget to add some logic to exit...
July 6, 2020 at 12:16 pm
If you can't add columns\objects that can only be done by dynamic SQL. If you can create objects, then you can create view that will have placeholder in some databases...
July 3, 2020 at 8:20 am
The query is doing following:
July 3, 2020 at 8:16 am
It seems that you are doing something wrong. Normally you don't need to update the history records. If you need to get the update time not in UTC, you just...
July 2, 2020 at 10:42 am
Viewing 4 posts - 16 through 19 (of 19 total)