kill update statistics in Sybase

The cronjob use to update statistics for sybase db still running since pas 3 days, if I decided to kill the sessions, will it rollback entire command or it will just stop with current which it progressing ?
motioneyeAsked:
Who is Participating?
 
Joe WoodhouseConnect With a Mentor Principal ConsultantCommented:
There's not really a lot to rollback in an update stats job because the only thing being written to are the system tables sysstatistics and systabstats.

Worst case you might lose the stats for whatever table the job is currently running on. Three days seems excessive to me though!

Any tables that it finished working on will be untouched by killing the job, you would only lose progress for the current table. (I sure hope a single table hasn't taken three days!!)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.