New answers tagged

0

If a job has to run in an interval, the job needs to be in the state 'SCHEDULED' in between. In case of a job chain, make sure that it actually has an ending, otherwise it will remain running forever. DBA_RUNNING_JOBS only shows the jobs that are in state 'RUNNING' make sure the chain has an END action.


0

I find this command helps to show index progress: db.currentOp().inprog.map(a => a.msg) [ undefined, undefined, undefined, undefined, undefined, undefined, "Index Build: scanning collection Index Build: scanning collection: 16448156/54469342 30%", undefined, undefined ]


0

If VS doesn't have access to the remote server, you can build SSIS package, upload it to the remote server and install using SSMS. Build SSIS project to create IPSAC file in BIN folder Copy IPSAC file to the remote server Go to the remote server => SSMS => Integration Services Catalog => create new folder Created folder will have 2 sub-folders, one ...


Top 50 recent answers are included