SQL environment is 2008
The sa account closed
On the same server multiple Job created, there are some Job steps would suddenly vanished, add again after step, may be missing or even on the same day and the next day,
Even these Job related maintenance plan also can appear error: unable to open?

CodePudding user response:

Profile with the period of operation, delete job can use stored procedures or direct delete MSDB corresponding table records, you can do with this to filter conditions to reduce the profiler to capture the amount of data

CodePudding user response:

reference no. 1 floor ZJCXC -- personal WeChat public same response:

profile with a period of operation, delete the job can use stored procedures or direct delete MSDB corresponding table records, you can do with this to filter conditions to reduce the profiler to capture the amount of data

Thanks for your reply, the key is there is the job itself, only on the steps in job disappeared, and the loss of the specific time have no way to confirm

CodePudding user response:

Steps to delete also can through the standard of the stored procedure to delete data in the table, so it can track